where VbNullString in VB.Net?

[Tark Siala]

hi
lasr years i use vb6 to make my Application Database with ADO, this days i
use VB.NET to working with Database.
to know if Field contain null i use:

if recordset.field("data").value = vbnullstring then .....

but when i use VB.Net and working with Database this command not working,
any one know how do it in VB.NET?

 

[rowe_newsgroups]

hi
lasr years i use vb6 to make my Application Database with ADO, this days i
use VB.NET to working with Database.
to know if Field contain null i use:

if recordset.field("data").value = vbnullstring then .....

but when i use VB.Net and working with Database this command not working,
any one know how do it in VB.NET?

How about using DbNull instead?

Thanks,

Seth Rowe

 

[pvdg42]

hi
lasr years i use vb6 to make my Application Database with ADO, this days i
use VB.NET to working with Database.
to know if Field contain null i use:

if recordset.field("data").value = vbnullstring then .....

but when i use VB.Net and working with Database this command not working,
any one know how do it in VB.NET?

Try here:

http://msdn2.microsoft.com/en-us/library/system.dbnull.value(VS.80).aspx

 

[Herfried K. Wagner [MVP]]

lasr years i use vb6 to make my Application Database with ADO, this days i
use VB.NET to working with Database.
to know if Field contain null i use:

if recordset.field("data").value = vbnullstring then .....

but when i use VB.Net and working with Database this command not working,
any one know how do it in VB.NET?

\\\
If ... Is DBNull.Value Then
...
End If
///

'IsDBNull' provides a wrapper around this comparison.

 

[aaron.kempf]

that has got to be the most ridiculous thing I've ever heard.

Is M$ going to change this yet again in the next version?

is UNNECESSARY CHANGE _SEXY_?
is UNNECESSARY CHANGE _NECESSARY_?

 

[Tark Siala]

thanks
its working now.

 

[Michael C]

hi
lasr years i use vb6 to make my Application Database with ADO, this days i
use VB.NET to working with Database.
to know if Field contain null i use:

if recordset.field("data").value = vbnullstring then .....

but when i use VB.Net and working with Database this command not working,
any one know how do it in VB.NET?

All the difference styles of nothing-ness (vbnullstring, nothing, emtpy,
missing and null) and gone except for nothing and DBNull.Value. DBNull.Value
is something (as opposed to nothing).

Michael