how can i check if my dataset is empty?

[yaniv]

MY dataset is built on a query that can return no values at all.

can i check if it is empty before i"m starting to suck the data?

[Nerseus]

You can check the DataTable's Rows.Length (or is it Count?) property. Assume you have a table in your dataset named "Table1":

if(ds.Tables["Table1"].Rows.Length > 0)
{
   // You have data
}
else
{
   // You have no data
}

 

-Nerseus

[Robby]

I think it's count..

ds.Tables(0).Rows.Count

[yaniv]

Well, it was Count indeed.

thanks guys.