Null Error

[Erik]

I have a Windows form that does a insert and then a update to a dataset.
When I do the insert/update and all the fields are filled in it works fine.
But when there is a null value or when the field is empty I get the usual
update error.
I'm using a Access database and none of the fields are required.
I don't want to have to make a seperate object to merge the changes like
most of my forms do.
VB6 had shortcuts and I would like to use one in VB.NET

I want to have a If Then Else or something to use as a shortcut around this.
Like:
If textbox1 = NULL then
skip
Else
Add textbox1.text = recordset.....

I have found limited info on the Null field problem. Something like
System.DBNULL
In the old way I would do something like a IIF(NULL) etc...

Does anybody have any ideas.

Thanks.

Erik

[William Ryan]

http://www.knowdotnet.com/testsite/nullvalues.html
"Erik" <ER*******@pacificdesignstudios.com> wrote in message
news:#K**************@tk2msftngp13.phx.gbl...

I have a Windows form that does a insert and then a update to a dataset.
When I do the insert/update and all the fields are filled in it works fine. But when there is a null value or when the field is empty I get the usual
update error.
I'm using a Access database and none of the fields are required.
I don't want to have to make a seperate object to merge the changes like
most of my forms do.
VB6 had shortcuts and I would like to use one in VB.NET

I want to have a If Then Else or something to use as a shortcut around this. Like:
If textbox1 = NULL then
skip
Else
Add textbox1.text = recordset.....

I have found limited info on the Null field problem. Something like
System.DBNULL
In the old way I would do something like a IIF(NULL) etc...

Does anybody have any ideas.

Thanks.

Erik