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);
