How to count total number of row

string connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your .mdb file;";

string sql = "select COUNT(*) AS StudCount from student";

OleDbConnection connection = new OleDbConnection(connetionString);

OleDbDataAdapter dataadapter = new OleDbDataAdapter(sql, connection);

DataSet ds = new DataSet();

connection.Open();

dataadapter.Fill(ds);

connection.Close();

dataGridView1.DataSource = ds;

OleDbConnection my_con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C\db.accdb");

my_con.Open();

OleDbCommand cmds = new OleDbCommand("select COUNT(*) AS StudCount from student", my_con);

OleDbDataAdapter da = new OleDbDataAdapter(cmds);

DataTable dt = new DataTable();

da.Fill(dt);

lblCounter.Text = dt.Rows[0][" StudCount "].ToString();