private void button3_Click(object sender, EventArgs e) { int sex; SqlConnection con = new SqlConnection(); con.ConnectionString = KetNoi.str; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; string TenLop; TenLop = cbxTenLop.SelectedItem.ToString(); cmd.CommandText = "select* from Lop where TenLop ='" + TenLop + "'"; SqlDataReader rd; rd = cmd.ExecuteReader(); DataTable td = new DataTable(); td.Load(rd); string MaLop = td.Rows[0][0].ToString(); if (radioButton7.Checked == true) { sex = 0; } else { sex = 1; } cmd.CommandText = "INSERT INTO SinhVien VALUES('" + txtmaSV.Text + "','" + txtTenSV.Text + "'," + sex + ",'" + mskNgaySinh.Text + "','" + txtNoiS.Text + "','" + txtTT.Text + "','" + txtKH.Text + "','" + txtLL.Text + "','" + MaLop + "','" + hinhanh + "')"; cmd.ExecuteNonQuery(); con.Close(); string strmasv; string strtensv; strtensv = txtTenSV.Text; strmasv = txtmaSV.Text; frmthemkqSV frm = new frmthemkqSV(strmasv, strtensv); frm.Show(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = KetNoi.str; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; string TenMonHoc; TenMonHoc = cbxmonhoc.SelectedItem.ToString(); cmd.CommandText = "select* from MonHoc where TenMonHoc ='" + TenMonHoc + "'"; SqlDataReader rd; rd = cmd.ExecuteReader(); DataTable td = new DataTable(); td.Load(rd); string MaMonHoc = td.Rows[0][0].ToString(); int LanThi; LanThi = Convert.ToInt16(txtLanThi.Text); double DiemThi; DiemThi = Convert.ToDouble(txtDiemThi.Text); double TongKet; TongKet = Convert.ToDouble(txtTongKet.Text); cmd.CommandText = "INSERT INTO KetQua VALUES('" + MaMonHoc + "','" + masv + "'," + LanThi + "," + DiemThi + "," + TongKet + ")"; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Thêm Dữ Liệu Thành Công!"); Close(); frmthemkqSV frm = new frmthemkqSV(masv, tensv); frm.Show(); }