I am having a problem on setting the SQL CE table column a field type. What field type does a column that only accepts only two inputs..
Example: If a table has a column named Gender..it should only accepts two types of input...like Make or Female.
On geting input into DataGridViewTextBoxColumn but the column should not accept input of data that is not integer like; 10003, 2.00, 1500.00
View 3 RepliesSome codes here on how could I validate my datagridview? I mean, a certain column on my datagridview should accept integers only, otherwise, it will return a messagebox. Kindly include on which event it should be posted.
View 17 RepliesThis should be an easy one, looks like I got myself too confused.I get a table from a database, data ranges from varchar to int to Null values. Cheap and dirty way of converting this into a tab-delimited file that I already have is this (shrunken to preserve space, ugliness is kept on par with original):
da.Fill(dt)
' da - DataAdapter '
' dt - DataTable '
[code].....
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
View 3 RepliesI am writing a calculator app in VB Express 2008. I'm trying to get the app to accept numeric and operator input while ignoring all the alpha input. In other words taking input from the numeric keypad and the top of the keyboard and ignoring all the letters.
Here's the block of code I have so far:
Private Sub TextBox1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown
If (e.KeyCode >= Keys.D0 OrElse e.KeyCode >= Keys.NumPad0) And (e.KeyCode <= Keys.D9 OrElse e.KeyCode <= Keys.NumPad9) Then
Select Case e.KeyCode
[code]....
I can't get vb to recognize the above code it seems to skip right over it. BTW, is 'Keys.Crsel' the same as the caret '^' symbol?
This is the program that i made for class to be a calculator for shopping
Public Class frmHarrysGroceryCalculator
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
'exit button ep
[code]....
I want to be able to use the @ i.e 3@10, meaning 3 items at 10 dollars, in the input box.
In VB.net ,how to accept multiple input? I want to enter marks of a student in 5 subjects to find percentage of marks,but i am not able to understand which vb.net statement i should use to take input in a single line
View 4 RepliesProblem Specification: The Caswell Catering and Convention Service want to install a computerized billing system. You are to develop the application to accept as input the following items:
a.The Name of the customer (string).
b.The number of adults to be served (byte).
c.The number of children to be served (byte).
d.The cost per adult meal (single).
e.The room fee (no room fee if catered at the person's home).
f.Amount of deposit which is deducted from the bill.
The following is a sample application's input section [code]...
SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
View 4 RepliesHow to accept input into a vb.net console application? How Do I allow people to type into a vb.net console application, and then press enter, and then the console application writes that and uses the console.writeline function to write what the person typed in into the network stream(or whatever its called).
View 10 RepliesHow do I validate textboxes so that they accept only numerical input (1 2 3 etc and not abc @$ etc)? Is there some kind of property of the textbox that I have to change?
View 1 RepliesI need to write a program using a For Next loop to accept a word as input and determine if its letters are in alphabetical order.
This is the code I came up with but am getting the error "Index and length must refer to a location within the string. Parameter name: length" at run time when I click the button.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
This function doesn't work if I change the input argument 'pdu' from a string to an int.Would someone please help me figure out what to do here so that the checksum does not add the ascii value of the int argument but rather the actual integer value?I took out a few lines of the actual function but it adds the input argument to a packet sent out via TCP protocol.This function shows the integer value just fine in the string that gets encoded as a byte array. the checksum is wrong.!
''Public Function buildpacket(pdu As Integer) is what I want.
Public Function buildpacket(pdu As String)
Dim packet As String
[code]....
I have written a custom Bindable RichText Box, so I can bind to the Document property. However, as soon as I set my document content, the only keyboard input it accepts is the backspace key (???). No other keyboard input is acknowledged (including the arrow keys).
[Code]...
how to set the limit of a certain column to accept 10 the same inputs only. I have a table named Date and I want to limit its content for the same inputs to 10 only cause 10 person only can have the same date.
View 14 RepliesHow can I block a column from a datagridview to accept only values like hh:mm style and nothing else. And how to handle errors when user is inserting something else than time format?
View 2 RepliesHow do I declare that my column 4 should accept integers only?
View 1 RepliesIs there any way to set a column to accept only unique values?(Via Table Definition)
View 2 RepliesI am developing a s/w. I am trying to update data in table. While I save the data, it will update into table. I have a gridview which binds table data through dataset. While I update the changes it is not reflecting in the grid view.
What I will do inorder to update the changes into gridview.
For some reason I have noticed that at run time when looking at my source of my ASP.NET page there are tags being created.
<input type="hidden" name="_VIEWSTATE" id="_viewstate" value="..lots of text.." />
and
<input type="hidden" name="_EVENTVALIDATION" id="_EVENTVALIDATION" value="..lots of text.."
[code].....
I have face problem with null value i remove the chk from null value n sql server and when i direct save anything in table it dosen't accept null value but when i save these in my form it accept null value.
View 11 Repliesfor example if a person types in multiple characters that represent a certain image in the input box for example if i type "tom" in the input box each letter represents a different image. Can i display those 3 images on the form somewhere? this is what i have so far...
Dim character As String = InputBox("Please enter a word")
I know that much but im not sure how i can connect the letter with a image for example
PictureBox1.Image = My.Resources.pic02
i want t to = my.resources.pic02 and i want it to display on the picturebox1.image
I am trying to figure out how to make a program which can accept switches like cmd.exe /k or /c basically i want it to accept commands by myapp.exe /c mycommand.i tried searching and googling but no luck. Also is there a way to run a function like that? And if anyone is wondering why then basically i am copying a script to my domain computer and executing it. This i already have done but problem is its just getting too much copyin multiple scripts and executing i would put everything in on and run em by switches.
View 2 RepliesHow should i make a textbox to accept only string? And if there is error to appear the Error Provider. I have fixed it for the integer, but it doesnt work in string.
View 1 RepliesCommand line programs like ffmpeg.exe accept a parameter like so: c:> ffmpeg.exe -i img%03d.png img.gif This will grab all these images in the directory and use them inside the program:
[Code]....
Is there a clever way to implement this in my VB.net command line project, or do I have to parse the argument for the %0?
I am trying to make a textbox accept on the numbers 1-4 & the backspace key. The numbers part is working fine, but it will not delete the number once it's inputted into the box using backspace. Here's my existing code:
Private Sub txtCode_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtCode.KeyPress 'allows the textbox to only accept 1-4 & backspace If (e.KeyChar < "1" OrElse e.KeyChar > "4" _ AndAlso e.KeyChar = vbBack) Then e.Handled = True End
hows to make a textbox accept only numbers? and ".". i tried looking in the Help, couldnt find something relating to it. i guess it's something to do with the keys pressed on the keyboard so if i could determine and reject certain keys (anything thats not a number) it could work.
View 6 RepliesI Want to make a class accept string variable like this
Dim mystring as custstring
mystring = "test var"
like how we declare string classes I tried to use property as such
Public class cust
dim inputstr as string = ""
Public Property cust() As String
Get
[code]....
But it doesn't seem to work?
I've got a little function that just changes empty and null strings to "null":
Public Function CatchString(ByVal stringValue As String) As String
If stringValue = "" Or stringValue Is Nothing Or stringValue Is DBNull.Value Then
Return "null"[code].....
I added the bit about DBNull because sometimes it gets null values from a database. This doesn't work, though, because it won't take DBNull as a parameter.I tried changing the stringValue parameter from a string to an object, but then the If statement gives this error:
Quote: Object reference not set to an instance of an object.How do I make the function accept DBNull as a parameter?