protected void Button6_Click(object sender, EventArgs e) { //修改 DataClassesDataContext db = new DataClassesDataContext(); JB_khxx khxx = db.JB_khxx.Single <JB_khxx>(kh => kh.id == TextBox1.Text); khxx.mingcheng = TextBox2.Text; khxx.dianhua = TextBox3.Text; khxx.chuanzhen = TextBox4.Text; khxx.dizhi = TextBox5.Text; db.SubmitChanges(); // var khxxs = from k in db.JB_khxx where (k.dizhi.Contains("") && k.id.Contains("")) select k; GV.DataSource = khxxs; GV.DataBind(); }
protected void GV_RowDeleting(object sender, GridViewDeleteEventArgs e) { string sid = GV.DataKeys[e.RowIndex].Value.ToString(); DataClassesDataContext db = new DataClassesDataContext(); JB_khxx khxx = db.JB_khxx.Single <JB_khxx>(kh => kh.id == sid); //var khs = from kh in db.JB_khxx // where kh.id == sid // select kh; //db.JB_khxx.DeleteAllOnSubmit<JB_khxx>(khs); // //List<JB_khxx> lst = khs.ToList<JB_khxx>(); db.JB_khxx.DeleteOnSubmit(khxx); db.SubmitChanges(); // var khxxs = from k in db.JB_khxx select k; GV.DataSource = khxxs; GV.DataBind(); }
partial void DeleteJB_khxx(JB_khxx instance);
private void InsertJB_khxx(JB_khxx obj) { this.UP_JB_khxx_ADD(obj.id, obj.mingcheng, obj.dianhua, obj.chuanzhen, obj.dizhi); }
partial void UpdateJB_khxx(JB_khxx instance);