void Load_Lable()
{
MyDb db = new MyDb();
SqlCommand command = new SqlCommand("select * from std ", db.getConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
int siso = table.Rows.Count;
lbSiso.Text = ("Tổng số học sinh:" + siso);
SqlCommand command1 = new SqlCommand("select * from std where gender=@Gender", db.getConnection);
command1.Parameters.Add("@Gender", SqlDbType.VarChar).Value = "Female ";
SqlDataAdapter adapter1 = new SqlDataAdapter(command1);
DataTable table1 = new DataTable();
adapter1.Fill(table1);
int sisonu = table1.Rows.Count;
double nu = (sisonu * 100) / siso;
lbNu.Text = ("Nu:" + Math.Round(nu, 2));
double nam = 100 - nu;
lbNam.Text = ("Nam: " + Math.Round(nam, 2));
}
