Another select statement

[GaryMazzone]

If using ADO and VB6 test for recordset EOF and BOF if they are true then No records.

If using ADO.Net and VB.Net for Datareaders check the .HasRows property. For DataSets test if the dataset.Table(#).Rows.RowCount() > 0

[GUARO]

Gary/L

Thanks a bunch, here I am on my first application using .net and having this kind of problems, so thanks for battling with me here

I was trying to get the same prop or meth from datatable.

I am using sqlclient to connect to the sql server


so I have a sqladapter.fill(ds) where ds is my datatable object
then I populate my datagrid with my ds

But before I do all this I would like to know if the select statement comes back with something or not

Thanks again