I'm using VB.NET (not 2003) and want to know how I can determine whether or not a dataset I've created actually HAS any data in it. I know in 2003, you can use the .hasrows function, but I'm not sure how to do this in the first version.
I ask because I have several query possibilites a user can select. From the query, the results are populated in a datagrid. If there aren't any results in the grid, I want to tell the user that no results were found..not just that for some reason the grid didn't populate.

ANY help would be appreciated.

Hi there,

You can check the Count property of the Rows collection of the DataTable you're interested in:

If (MyDataSet.Tables("MyTable").Rows.Count > 0)
  ' Has Data
Else
  ' No Records
End If

AFAIK, the HasRows only applies to a DataReader and not to a DataSet. Were you referring to a DataReader?

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks. I'll try that! ;)

But were you talking about a DataReader or a DataSet?

With a Reader, you can't use the code I showed you. Instead, you should bind your data to your control (a Repeater, a DataGrid, etc) and then check its Item.Count property:

If DataGrid1.Items.Count > 0 Then
  ' Data
Else
  ' No Data
  ' DataGrid1.Visible = False
  ' lblNoRecords.Visible = True
End If

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks a ton, that just bailed me out.