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

Popular Posts