Spent a bit this morning wading through .NET documentation trying to find out how one retrieves the number of records returned from a query. Turns out it’s pretty simple. First you get your query rolling:<\/p>\n
\/\/ get the connection string from settings At this point you’ve run the query and you have a DataSet which you can then loop over like any other collection, ie:<\/p>\n foreach (DataRow<\/a> d in dataset.Tables[“mytable”].Rows)<\/p>\n or you can retrieve the number of rows:<\/p>\n DataRowCollection<\/a> drc = dataset.Tables[“mytable”].Rows; or even quicker like this:<\/p>\n Console.WriteLine(“there are ” + dataset.Tables[“mytable”].Rows.Count + ” rows in the query.”);<\/p>\n Back to work….<\/p>\n","protected":false},"excerpt":{"rendered":" Spent a bit this morning wading through .NET documentation trying to find out how one retrieves the number of records returned from a query. Turns out it’s pretty simple. First you get your query rolling: \/\/ get the connection string from settings String cs = System.Configuration.ConfigurationSettings.AppSettings[“connectionString”].ToString(); \/\/ get a sql connection using the connection string … Continue reading Retrieving ‘recordcount’ property in .NET<\/span>
\nString cs = System.Configuration.ConfigurationSettings.AppSettings[“connectionString”].ToString();
\n\/\/ get a sql connection using the connection string
\nSqlConnection<\/a> sqlcon = new SqlConnection(cs);
\nSqlDataAdapter<\/a> adapter= new SqlDataAdapter(“select * from yourtable”, sqlcon);
\nDataSet<\/a> dataset = new DataSet();
\nadapter.Fill(dataset,”mytable”); <\/p>\n
\nConsole.WriteLine(“there are ” + drc.Count + ” rows in the query.”);<\/p>\n