count
string k2 = "select count(name) from regtb where status='" + status + "' ";
cm = new SqlCommand(k2, cn);
Label5.Text = cm.ExecuteScalar().ToString();
//direct print we used execute scalar
cm = new SqlCommand(k2, cn);
Label5.Text = cm.ExecuteScalar().ToString();
//direct print we used execute scalar