Click to See Complete Forum and Search --> : Check to see if dataset row is null


afterdark23
09-02-2005, 05:20 PM
How can I check to see if a dataset row is null?

Thanks in advance!!

Memnoch
09-03-2005, 12:00 AM
Example:

VB.NET
If DataSet.Tables(0).Rows(0).Item("FieldName") Is DBNull.Value Then

C#
if (DataSet.Tables(0).Rows(0).Item["FieldName"] == DBNull.Value);

Cstick
09-03-2005, 12:55 PM
Or this slightly shorter version of the same.

If IsDbNull(DataSet.Tables(0).Rows(0).Item("FieldName")) Then

riddim
02-07-2007, 04:49 PM
hey thanks alot guys!!