表所有字段為非空
加載ID主鍵
protected void Page_Load(object sender, EventArgs e)??? {??????? HRPaidTimeOffDataContext db = new HRPaidTimeOffDataContext();?????? ENTUserAccount useraccount= db.ENTUserAccount.Single(ua => ua.WindowsAccountName == @"VARALLO1\VaralloMadison");
?????? ViewState["ENTUserAccountID"] = useraccount.ENTUserAccountID;????????? }
?
執行刪除:
?protected void Button4_Click(object sender, EventArgs e)??? {??????? HRPaidTimeOffDataContext db = new HRPaidTimeOffDataContext();??????? try??????? {??????????? db.SubmitChanges(System.Data.Linq.ConflictMode.ContinueOnConflict);??????? }
??????? catch (System.Data.Linq.ChangeConflictException ex)??????? {??????????? foreach (System.Data.Linq.ObjectChangeConflict occ in db.ChangeConflicts)??????????? {??????????????? occ.Resolve(System.Data.Linq.RefreshMode.OverwriteCurrentValues);??????????? }??????? }??????? ENTUserAccount useraccount = new ENTUserAccount();
??????? useraccount.ENTUserAccountID = Convert.ToInt32(ViewState["ENTUserAccountID"]);??????
??????? db.ENTUserAccount.Attach(useraccount);??????? db.ENTUserAccount.DeleteOnSubmit(useraccount);??????? db.SubmitChanges();//此處報錯“找不到行或行已更改”
??? }
沒做更新,是否刪除也要添加時間戳?
- 3 回答
- 0 關注
- 903 瀏覽
添加回答
舉報
0/150
提交
取消