Ajay_Kumar Ajay_Kumar - 9 days ago 5
C# Question

how to count the total number of row in oledbconnection in c#.net

how to count the total number of row in oledbconnection in c#.net

I want to count how many rows are present in my table.

string dataReader = "SELECT count(*) from `Email_account_list`";
OleDbCommand command_reader = new OleDbCommand(dataReader, myConnection);
OleDbDataReader row_reader = command_reader.ExecuteReader();


What function i will write to fetch total number of rows present in table.

Answer

A SELECT COUNT(*) statetment is a special (SELECT) statement in that you should not use ExecuteReader() but instead use int rowCount = (int) command.ExecuteScalar();