SqlCommand Record Count

Question

SqlCommand Command = this.CreateCommand(String.Format("SELECT {0} FROM {1} WITH (NOLOCK) ORDER BY ID", String.Join(",", this.m_Campaign.Fields.ToArray()), _Tablename));

How can I go about getting the record count of this query? I need to know how many records it's retrieving.

Jan Montano · Answer

normally you will need to do a SELECT COUNT statement first to retrieve the number of rows before doing your SELECT * statement. You need to do two calls. Or using sqlCommand.ExecuteReader() you need to iterate the list in the dataReader before actually knowing how many rows you got. Or when using dataadapter Dataset rows count will return the number of rows to you. Have a research on SqlDataReader & SqlDataAdapter to know which approach suits your requirements best.