determining number of query records...

[Sheffield]

Greetings,

I'm a .NET newbie unable to determine the number of records being returned by a query. I was expecting a RecordCount property or something, but I can't find any documentation on it. Ugh!!!

Can someone please clue me in?

Thanks

 

[eb24]

Depends what type of Data Control you'll be using. Please elaborate.

 

[Sheffield]

well, in one instance, I'm populating a DataGrid and in another I'm populating a DropDownList.

I just need to make some decisions in the code based on the presence or absence of records returned by the query.

I realize I could perform an additional query using

SELECT Count(*) FROM...

via the ExecuteScalar method but that seems like there should be a more simple way to achieve the same result.

Thanks

 

[LV]

You can use a SqlDataReader object to bind your controls to and use its HasRows property:

if(myReaderHasRows)
{
 //bind control
}
else
{
  // display "No Records" message
}

 

[LV]

Sorry, should read

if(myReader.HasRows)