Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SqlDataReader count rows??
- Thread starter djam
- Start date
"When you have a SqlDataReader object, you can count only the records when iterating the reader:
int iCount=0;
while(myReader.Read())
{
iCount++;
}
myReader.Close();
If you are interested to count only the records returned by a query then use ExecuteScalar() instead of using a DataReader object:
string mySQL="select ....";
string myScalarQuery= "select count(*) as NumberOfRecords from (" + sSQL + ") as t1";
SqlCommand myCommand = new SqlCommand(myScalarQuery, myConnection);
myCommand.CommandText = myScalarQuery;
myCommand.Connection.Open();
Int32 iCount = (int) ExecuteScalar();
-obislavu-
int iCount=0;
while(myReader.Read())
{
iCount++;
}
myReader.Close();
If you are interested to count only the records returned by a query then use ExecuteScalar() instead of using a DataReader object:
string mySQL="select ....";
string myScalarQuery= "select count(*) as NumberOfRecords from (" + sSQL + ") as t1";
SqlCommand myCommand = new SqlCommand(myScalarQuery, myConnection);
myCommand.CommandText = myScalarQuery;
myCommand.Connection.Open();
Int32 iCount = (int) ExecuteScalar();
-obislavu-
- Status
Similar threads
- Locked
- Question
- Locked
- Question