//插入语句 protected void Button1_Click(object sender, EventArgs e) { DataClassesDataContext dcdc = new DataClassesDataContext( ConfigurationManager.ConnectionStrings["MyDataBaseConnectionString"].ConnectionString.ToString()); YuShouKuan ysk = new YuShouKuan(); ysk.所属公司 = TextBox1.Text; ysk.金额 = double.Parse(TextBox2.Text); ysk.收款人 = TextBox3.Text; //插入语句 dcdc.YuShouKuan.InsertOnSubmit(ysk); //提交修改 dcdc.SubmitChanges(); }
//修改语句 protected void Button2_Click(object sender, EventArgs e) { DataClassesDataContext dcdc = new DataClassesDataContext( ConfigurationManager.ConnectionStrings["MyDataBaseConnectionString"].ConnectionString.ToString()); YuShouKuan ysk = new YuShouKuan(); //这里的v类似临时表 var result = from v in dcdc.YuShouKuan where v.ID == 47 select v; foreach (var item in result) { item.收款人 = "神海龙"; } //提交修改 dcdc.SubmitChanges(); }
partial void UpdateYuShouKuan(YuShouKuan instance);
partial void DeleteYuShouKuan(YuShouKuan instance);
partial void InsertYuShouKuan(YuShouKuan instance);