public tacgia LayDuLieuTuForm() { tacgia tg = new tacgia() { MaTacGia = txtMaTacGia.Text, TenTacGia = txtTenTacGia.Text }; return(tg); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { string maTacGia = GridView1.SelectedRow.Cells[0].Text; tg = cn.GetTacGiaByID(maTacGia); if (tg != null) { txtMaTacGia.Text = tg.MaTacGia; txtTenTacGia.Text = tg.TenTacGia; } }
public bool UpdateTacGia(tacgia tg) { using (SqlConnection conn = new SqlConnection(connect)) { string sql = "update TacGia set TenTacGia=@ten where MaTacGia=@ma"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ma", tg.MaTacGia); cmd.Parameters.AddWithValue("@ten", tg.TenTacGia); conn.Open(); int count = (int)cmd.ExecuteNonQuery(); return(count >= 1); } }
public bool InsertTacGia(tacgia tg) { using (SqlConnection conn = new SqlConnection(connect)) { string sql = "insert into TacGia values(@ma,@ten)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ma", tg.MaTacGia); cmd.Parameters.AddWithValue("@ten", tg.TenTacGia); conn.Open(); int count = (int)cmd.ExecuteNonQuery(); return(count >= 1); } }
protected void btnSua_Click(object sender, EventArgs e) { tg = LayDuLieuTuForm(); bool result = cn.UpdateTacGia(tg); if (result) { lblThongBao.Text = "Cập nhập thành công"; DoDuLieuVaoGridView(); } else { lblThongBao.Text = "Có lỗi"; } }
public tacgia GetTacGiaByID(string maTacGia) { using (SqlConnection conn = new SqlConnection(connect)) { string sql = "select * from TacGia where MaTacGia=@ma"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ma", maTacGia); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { tacgia tg = new tacgia() { MaTacGia = (string)dr["MaTacGia"], TenTacGia = (string)dr["TenTacGia"] }; return(tg); } return(null); } }
protected void btnThem_Click(object sender, EventArgs e) { tg = LayDuLieuTuForm(); cn = new chucnang(); bool exist = cn.CheckMaTacGia(tg.MaTacGia); if (exist) { lblThongBao.Text = "Tác Giả này đã có"; } else { bool result = cn.InsertTacGia(tg); if (result) { lblThongBao.Text = "Thêm thành công"; DoDuLieuVaoGridView(); } else { lblThongBao.Text = "Có lỗi"; } } }