Checking Record Set (VS)

[TheConeHead]

I am tranisitioning from asp to asp.net and have some basic questions... I am dev. from visual studio. My first question is:

In asp I would create a record set and see if it is empty via:

if (!rs.eof && !rs.bof) {

How do I do this in .net - do I create a data reader?? I have the SQL connection and command in my code behind page but I can not figure out how to create a record set and simply check it....

 

[jbenson001]

You can create a dataset or datatable and check the rowcount, EX:

dim i as integer
i = ds1.Tables(0).Rows.Count