public bool editKhoa(khoa mk, string makhoa) { SqlConnection conn = new SqlConnection(connectString); string sql = "update KHOA set TenKhoa= @tenkhoa, SDT = @sodienthoai, Email = @email Where MaKhoa= @makhoa"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@makhoa", makhoa); cmd.Parameters.AddWithValue("@tenkhoa", mk.TenKhoa); cmd.Parameters.AddWithValue("@sodienthoai", mk.SDT); cmd.Parameters.AddWithValue("@email", mk.Email); conn.Open(); int count = cmd.ExecuteNonQuery(); conn.Close(); return(count >= 1); }
protected void Button2_Click(object sender, EventArgs e) { int SDT = int.Parse(txtSDT.Text); khoa kh = new khoa(txtTK.Text, SDT, txteml.Text); if (khoadao.editKhoa(kh, txtMK.Text)) { lblTB.Text = "Đã EDIT"; gvKhoa.DataSource = khoadao.getTable("select * from KHOA"); gvKhoa.DataBind(); } else { lblTB.Text = "ERROR"; } }
protected void Button1_Click(object sender, EventArgs e) { int sdt = int.Parse(txtSDT.Text.ToString()); khoa kh = new khoa(txtTK.Text, sdt, txteml.Text); if (khoadao.addKhoa(kh)) { lblTB.Text = "Successfully"; gvKhoa.DataSource = khoadao.getTable("select * from KHOA"); Page.DataBind(); } else { lblTB.Text = "Failed "; } }
public bool addKhoa(khoa kh) { SqlConnection conn = new SqlConnection(connectString); // khoa kh = new khoa( txtTK.Text,sdt ,txteml.Text); string sql = @"INSERT INTO KHOA(TenKhoa, SDT, Email) VALUES (@tenkhoa, @sdt, @email)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@tenkhoa", kh.TenKhoa); cmd.Parameters.AddWithValue("@sdt", kh.SDT); cmd.Parameters.AddWithValue("@email", kh.Email); conn.Open(); int dem = cmd.ExecuteNonQuery(); conn.Close(); return(dem >= 1); }