Assign quoted null values to integer

[trenta87]

Im creating a program where users need to fill out a form with a number of textboxes. Ive created all the correct classes and some variables are integer types. The thing is i want to be able to have some textboxes left blank the program will still create an instance of a class and this information saved to access database. I get an error message saying conversion from type string "" to interger is invalid! Is there a way i can bypass this error and still have null values assigned to an integer???

 

[macleod1021]

From what you said, I'm guessing that you get the error when you try to convert the contents of the textbox to an integer to add it to the database. If that's the case, then add a check before making the conversion.

 

[Qamgine]

You need to catch the null value ("") and pass Nothing to the data table instead of trying to pass "".

If TextBox1.Text = "" Then
paramValue.Value = Nothing
Else
paramValue.Value = TextBox1.Text
End If

 

[PRPhx]

Take a look here for an explanation of how VB handles Null values for integers:

http://www.panopticoncentral.net/archive/2004/06/04/1180.aspx

Basically, in VB.net, integer values that are 'NULL' get assigned the value of 0 (zero).