SqlDataAdapter and SqlDataReader

Question

I have a stored procedure which returns a certain number of rows.

Case 1: When I use SqlDataAdapter

SqlDataAdapter sdAdapter = new SqlDataAdapter();
ds = new DataSet();
sdAdapter.SelectCommand = myCommand;
sdAdapter.Fill(ds);
int recordCount = ds.Tables[0].Rows.Count;

Case 2: When I use SqlDataReader

SqlDataReader reader = myCommand.ExecuteReader();
if (reader.HasRows)
{
   while (reader.Read())
    {
     recordCount++;
    }
 }

In Case 1, the recordCount is 15 which is correct.

In Case 2, for some reason, reader.HasRows is returning false.

Am I doing anything wrong in terms of syntax? I am confident that myCommand has been built properly since I do get the count in Case 1.

Any help would be really appreciated.

Thank you

Hi, if I comment the reader.HasRows in Case 2, I am still able to perform reader.Read() and get the value of recordCount. So just wondering is it is possible that hasRows return false but there is still reader pointing to the contents of the query? — blue piranha
– blue piranha, Commented Feb 16, 2013 at 2:49

smartyhunter · Accepted Answer · 2013-03-15 16:36:55Z

1

1.A DataReader works in a connected environment, whereas DataSet works in a disconnected environment. 2.A DataSet represents an in-memory cache of data consisting of any number of inter related DataTable objects. A DataTable object represents a tabular block of in-memory data.

more detail go to sqldataadapter or sqldatareader

answered Mar 15, 2013 at 16:36

smartyhunter

191 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 10:32:01Z

0

if (reader.HasRows) is redundant. When you say while (reader.Read()), it will only loop if there are any rows. Also, this link will explain that HasRows requires a scrollable cursor. Read about the cursors here.

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Feb 16, 2013 at 3:08

MaxDataSol

3561 gold badge2 silver badges18 bronze badges

Collectives™ on Stack Overflow

SqlDataAdapter and SqlDataReader

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related