private void btnTinhdiem_Click(object sender, EventArgs e) { string sql; double Diem = 0, BanThangDN, BanThangDK; BanThangDK = Convert.ToDouble(DAO.GetFieldValues("select sobanthuadoinha from trandau where matrandau = N'" + txtMaTran.Text + "'")); BanThangDN = Convert.ToDouble(DAO.GetFieldValues("select sobanthangdoinha from trandau where matrandau = N'" + txtMaTran.Text + "'")); //Diem = Convert.ToDouble(DAO.GetFieldValues("select diem from doibong where diem = N'" + txtDiem.Text + "'")); if (BanThangDN > BanThangDK) { Diem = Diem + 3; } else if (BanThangDN == BanThangDK) { Diem = Diem + 1; } DAO.OpenConnection(); sql = "UPDATE CapNhatĐB SET diem =" + Diem + " WHERE madoi = N'" + cmbMaDoiNha.SelectedValue + "'"; sql = "UPDATE CapNhatĐB SET diem =" + Diem + " WHERE madoi = N'" + cmbMaDoiKhach.SelectedValue + "'"; txtDiem.Text = Diem.ToString(); DAO.LoadDataToTable(sql); LoadDataToGrivew(); DAO.CloseConnetion(); }