//插入语句
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);
