public static void UpdateSV(tblSinhVien gv)
{
SqlConnection Conn = dbConnectionData.ketnoi();
SqlCommand command = new SqlCommand("pr_SinhVien_Update", Conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@MaSV", SqlDbType.NVarChar, 10);
command.Parameters.Add("@HoTen", SqlDbType.NVarChar, 100);
command.Parameters.Add("@NgaySinh", SqlDbType.DateTime, 50);
command.Parameters.Add("@GioiTinh", SqlDbType.NVarChar, 10);
command.Parameters.Add("@QueQuan", SqlDbType.NVarChar, 100);
command.Parameters.Add("@DiaChiHT", SqlDbType.NVarChar, 100);
command.Parameters.Add("@MaLop", SqlDbType.NVarChar, 10);
command.Parameters.Add("@SoTinChiDaDat", SqlDbType.Int, 10);
command.Parameters.Add("@DiemTichLuy", SqlDbType.Float, 10);
command.Parameters.Add("@SoTinChiDaDKi", SqlDbType.Int, 10);
command.Parameters["@MaSV"].Value = gv.MaSV1;
command.Parameters["@HoTen"].Value = gv.HoTen1;
command.Parameters["@NgaySinh"].Value = gv.NgaySinh1;
command.Parameters["@GioiTinh"].Value = gv.GioiTinh1;
command.Parameters["@QueQuan"].Value = gv.QueQuan1;
command.Parameters["@DiaChiHT"].Value = gv.DiaChiHT1;
command.Parameters["@MaLop"].Value = gv.MaLop1;
command.Parameters["@SoTinChiDaDat"].Value = gv.SoTinChiDaDat1;
command.Parameters["@DiemTichLuy"].Value = gv.DiemTichLuy1;
command.Parameters["@SoTinChiDaDKi"].Value = gv.SoTinChiDaDKi1;
Conn.Open();
command.ExecuteNonQuery();
Conn.Close();
}
private void btnSua_Click(object sender, EventArgs e)
{
try
{
string masv = txtMaSV.Text;
string ten = txtTenSV.Text;
DateTime ns = DateTime.Parse(dtpNgaySinh.Text, CultureInfo.InvariantCulture);
string gt = comboBox1.Text;
string qq = txtQueQuan.Text;
string dc = txtDiaChiHT.Text;
string mal = cboMaLop.Text;
int dd = int.Parse(txtSoTCDaDat.Text, CultureInfo.InvariantCulture);
float diem = float.Parse(txtDiemTichLuy.Text, CultureInfo.InvariantCulture);
int dk = int.Parse(txtSoTCDaDKy.Text, CultureInfo.InvariantCulture);
tblSinhVien hp = new tblSinhVien(masv, ten, ns, gt, qq, dc, mal, dd, diem, dk);
busSinhVien.InsertSinhVien(hp);
MessageBox.Show("them " + ten + " thanh cong");
dgvSinhVien.DataSource = busSinhVien.getSinhVien();
}
catch
{
MessageBox.Show("co loi xay ra");
}
}
