allow null value in textfield 1

[Jaminj]

Hello. I am using the following code to insert values from textboxes to an sql database:

cmdInsert.Parameters.Add( "@cigbook", SqlDbType.Money ).Value = txtcigbook.Text

How do I modify this to allow null values? I get an error when I try to submit the form if all the fields are not filled out. I am using Visual Studio .NET. Thanks.

 

[SqueakinSweep]

use the IsNull() function to check txtcigbook.text. If you want to pass Null as a Parameter, then the field in the SQL Table must also allow Nulls. This is specified in the Table Design.



Sweep
...if it works dont f*** with it

 

[dolfo35]

Jaminj, this has worked for me in the past:

If trim(txtcigbook.text) = "" then
  cmdInsert.Parameters.add("@cigbook", SqlDbType.Money).value = DBNull.Value
Else
  cmdInsert.Parameters.add("@cigbook", SqlDbType.Money).value = txtcigbook.text
End If

Hope that helps.
Rudy

 

[Jaminj]

Thanks guys. I used the solution that dolfo35 provided and it works perfect.