where VbNullString in VB.Net?

  • Thread starter Thread starter Tark Siala
  • Start date Start date
T

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?
 
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?
Click to expand...

How about using DbNull instead?

Thanks,

Seth Rowe
 
Tark Siala said:
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?
Click to expand...

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

'IsDBNull' provides a wrapper around this comparison.
 
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_?
 
ark Siala said:
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?
Click to expand...

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
 
Back
Top