How to count the number of rows from sql table in c#?
You may try like this:
select count(*) from tablename where columname = 'values'C# code will be something like this:-
public int A(){ string stmt = "SELECT COUNT(*) FROM dbo.tablename"; int count = 0; using(SqlConnection thisConnection = new SqlConnection("Data Source=DATASOURCE")) { using(SqlCommand cmdCount = new SqlCommand(stmt, thisConnection)) { thisConnection.Open(); count = (int)cmdCount.ExecuteScalar(); } } return count;}