ADO equivalent of .EOF

[TheWizardofInt]

I used the stock code to open my SQL table and return the dataset "User" where a Username and Password match what is entered on a login screen

Using a SQL query I return a dataset from the function.

I now want to know if the dataset is empty or not.

Anyone know how to actually READ the field values in ADO.net? I am going nuts with this

Thanks

 

[Thinker]

Are you using a DataAdapter? If so, you should check the return
value from the Fill method when you use it to populate your
dataset. Once you have used Fill, a new Table object will have
been added to the DataSet Tables collection. The Table object
has both a Rows and a Columns collection. As each Row object
is selected, the Columns objects have the values for that Row.
This is all just theory to me that I got from MSDN and an ADO.Net
reference. However, it makes sense to me, and I expect it works
pretty much as described.

 

[Derek Stone]

In a case like this where no data is ever displayed (as far as I know) Id suggest using a DataReader object instead, the .Read method returning False if no data has been returned.