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;

Hello, Tell me more about the type of application you have. Is it a windows form, console application or a website? Nicolas.