if string is empty insert dbnull

[Guest]

I have a form that has several fields that need to update a db record using
SQL Data Provider. What is the best practice to insert DBNull if a text field
is empty?

I normally use if (txtbox.text == system.DBNull.Value) however, this case I
would like to set a variable to either the string or DBNull so I can simply
use it in the cmd.parameters.add functionality.

how would one declare a variable that could hold a string or dbnull.value?

Thanks

 

[Kevin Spencer]

how would one declare a variable that could hold a string or dbnull.value?

You wouldn't. What you CAN do is create a Command Parameter that has a
dbNull value.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.