return number of records selected

[Abdul Rhman Alsri]

how to get number of records selected?

SqlDataReader dr1 = cmd1.ExecuteReader();

[Dr Walt Fair PE]

I don't think you can tell ahead of time how many records will be returned. If you need to know that, then you can use a COUNT function in your SQL or loop through the records and count them as you go.

CQ de W5ALT

Walt Fair, Jr., P. E. Comport Computing Specializing in Technical Engineering Software

[User 4167136]

The other way will be to use a dataset and do a count of that dataset: SqlDataAdapter sqldataadap = new SqlDataAdapter(objCmd); //objCmd is your Sql Command Object DataSet ds = new DataSet(); sqldataadap.Fill(ds); //get the # of rows: int irow=ds.Tables[0].Rows.Count;

[Lost User]

After running any type of query just fire following query to know number of rows affected.

SELECT @@rowcount AS 'RowsChanged'

Hope this will help!

Jinal Desai - LIVE Experience is mother of sage....

[Saiyed Alam]

Fill a data adapter with a dataset. Then count the rows. Some thing like: int totalRow = Dataset.Tables[0].Rows.Count;

[Abhinav S]

The reader does not have a count. You could however use an ExecuteScalar to get the count. int i = (int)cmd1.ExecuteScalar();

[Johnny J]

How exactly do you reckon this will return the row count? What is cmd1.CommandText in this case?