protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int Ma_VP_canxoa = (int)GridView1.DataKeys[e.RowIndex].Value; LinQtoSQLDataContext tam_context = new LinQtoSQLDataContext(); Van_Phong obj = tam_context.Van_Phongs.SingleOrDefault(Van_Phong => Van_Phong.id == Ma_VP_canxoa); tam_context.Van_Phongs.DeleteOnSubmit(obj); tam_context.SubmitChanges(); show_chungloai(); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //tham chieu den các đối tượng tai dong hieu chinh hien tai TextBox txt_Ten_VP = GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox; //chuan bi int Ma_VP_dangsua = (int)GridView1.DataKeys[e.RowIndex].Value; LinQtoSQLDataContext tam_context = new LinQtoSQLDataContext(); Van_Phong obj = tam_context.Van_Phongs.SingleOrDefault(Van_Phong => Van_Phong.id == Ma_VP_dangsua); obj.id = Ma_VP_dangsua; obj.Ten_VP = txt_Ten_VP.Text; //thuc hien tam_context.SubmitChanges(); GridView1.EditIndex = -1; show_chungloai(); }
protected void btnThem_Click1(object sender, EventArgs e) { //them moi chung loại san pham LinQtoSQLDataContext tam_context = new LinQtoSQLDataContext(); string sql_maxid = "select Max(id) as MAXID from Van_Phong"; DataTable dt = XLDL.docbang(sql_maxid); int maxid = int.Parse(dt.Rows[0][0].ToString()); int mavanphong = maxid + 1; Van_Phong obj = new Van_Phong { id = mavanphong, Ten_VP = txtTenVanPhong.Text, }; tam_context.Van_Phongs.InsertOnSubmit(obj); tam_context.SubmitChanges(); show_chungloai(); }