Example #1
0
        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));
        }