protected void Button1_Click(object sender, EventArgs e) { GoodsTypeDataContext lq = new GoodsTypeDataContext(); //实例化LINQ类 GoodsType gt = new GoodsType(); //创建一个新对象 gt.tName = TextBox1.Text; //设置相应字段的值 lq.GoodsType.InsertOnSubmit(gt); //执行插入数据操作 lq.SubmitChanges(); //提交数据库 LoadDate(); }
protected void Button3_Click(object sender, EventArgs e) { GoodsTypeDataContext lq = new GoodsTypeDataContext(); var types = from gt in lq.GoodsType where gt.tName == TextBox4.Text select gt; foreach (var type in types) { lq.GoodsType.DeleteOnSubmit(type); } lq.SubmitChanges(); LoadDate(); }
protected void btnUpdate_Click(object sender, EventArgs e) { GoodsTypeDataContext lq = new GoodsTypeDataContext();//实例化LINQ类 var types = from gt in lq.GoodsType where gt.tName == TextBox2.Text select gt; foreach (var type in types)//遍历集合 { type.tName = TextBox3.Text; } lq.SubmitChanges();//提交数据库 LoadDate(); }