Checking for a null value in a dataset

[Lee Trotter]

I have a one record dataset with a number of fields. Some of the fields
have null values. When I try to use these field VB.Net thoughs an error
about them being null.

If DataRow.IsNull(objDS.Tables(0).Rows(0).Item(0)) Then
Gives me the error:

Reference to non-shared member 'Public Function IsNull ( ByVal columnName As
String ) As Boolean' requires an object reference.



Any ideas?

Thanks

 

[Miha Markic [MVP C#]]

You should use DataRow instance:
objDS.Tables(0).Rows(0).IsNull(overloaded)

 

[Scott M.]

IsNull was part of VB 6 use IsDBNull(value) or if ?? = DBNull.value instead.

 

[Calvin Luttrell/ProjectThunder.com]

Lee,

If Not IsDBNull(objDS.Tables(0).Rows(0).Item(0)) Then



End If

-Calvin Luttrell
www.projectthunder.com
Enter to win a XBOX or a Portable DVD Player
Monitored forums www.projectthunder.com/forums