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

Question

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

Vincent Maverick Durano · Answer

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 Gui · Answer

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 Durano · Answer

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(); } }

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

Answers (3)