How to count the the number of row in sql table from C#

Widy Gui

So I want to access the number of row in sql table...but I should write the code in c#..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vincent Maverick Durano11y ago
In the first option you don't need a DataGridView for that. You will only use that if you are going to fetch some data from database and store it in a DataTable. The DataTable will contain count of rows returned from the query.

In the second option, Yes replace "MyTable" with the table name from your sql database
Widy Gui11y ago
thanks before..
in the first option, do you mean I should make a datagridview to contain the table from sql??

what I want is exactly like the second option..
So I want to ask, Is YourTable is a name of my table in sql??
Vincent Maverick Durano11y ago
You could store the result set in a DataTable and the use the Rows.Count to get the total rows returned. For example:
DataTable dt = new DataTable();
using(SqlConnection connection = new SqlConnection(GetConnectionString())){
connection.Open();
string sql = "SELECT Field1, Field2 FROM YourTable";
using(SqlCommand cmd = new SqlCommand(sql,connection)){
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(dt);
}

}

int rowCount = dt.Rows.Count;

But if your intent is just the count and nothing else then you could like this:
DataTable dt = new DataTable();
using(SqlConnection connection = new SqlConnection(GetConnectionString())){
connection.Open();
string sql = "SELECT count(*) FROM YourTable";
using(SqlCommand cmd = new SqlCommand(sql,connection)){
double rowCount = (double)cmd.ExecuteScalar();
}

}