How to check to for empty fields in a dataset?

[Guest]

I have a dataset with columns let's say ssn, name. I want to check to make
sure there are no rows with a blank(or null or whatever) ssn in the dataset
before I continue on with my program. What is a quick way to do that? I'm
using vb.net. Thanks.

 

[Mona]

Hi,

You can check for this in your sql query by using the "WHERE SSN IS NOT NULL" clause
or if you want to do this in the dataset by looping through all the items and comparing each ssn
column item with system.dbnull

HTH

Mona[Grapecity]

 

[intrader]

You can use the 'Contains' method to test as in:

if(oTab.Columns.Contains('ssn'))