IDataReader - Any way to get the total rows?

c# count rows datareader
michael picture michael · Jul 18, 2011 · Viewed 8.4k times · Source

Is there any way to get the total number of rows returned from a SQL query (from the IDataReader) before iterating through the rows by using reader.Read();?

Answer

SLaks picture SLaks · Jul 18, 2011

No.

IDataReader is a simple forward-only view of a resultset; it cannot get a count.

Related questions

Getting a count of rows in a datatable that meet certain criteria

I have a datatable, dtFoo, and would like to get a count of the rows that meet a certain criteria. EDIT: This data is not stored in a database, so using SQL is not an option. In the past, I've …

Read More
Lists: Count vs Count()

Given a list, which method is preferred to determine the number of elements inside? var myList = new List<string>(); myList.Count myList.Count()

Read More
Count the number of times a string appears within a string

I simply have a string that looks something like this: "7,true,NA,false:67,false,NA,false:5,false,NA,false:5,false,NA,false" All I want to do is to count how many times the string "true" appears in that string. …

Read More