Site9527entitiesdatacontext (important class): connects entity and website list operations
Spcontext. Current. Web. url: Get the page of the current operation
Firstordefault: Must be referenced before use (using system. LINQ ;)
Datacontext. submitchanges (): Make sure that the data is updated to the list.
Add
protected void bt_SaveClic(object sender, EventArgs e) { using (Site9527EntitiesDataContext dataContext = new Site9527EntitiesDataContext(SPContext.Current.Web.Url)) { UserInfoItem user = new UserInfoItem(); user.Title = this.tx_Title.Text; user .UserName = this .tx_UserName.Text; user.Gender = this.tx_Gender.Text; user.Adress =this. tx_adress.Text; dataContext.UserInfo.InsertOnSumbit(user); dataContext.SubmitChangers(); } base.Response.Redirect("UserInfoList.aspx"); }
Delete
protected void bt_DeleteClick(object sender, EventArgs e) { using (Site9527EntitiesDataContext dataContext = new Site9527EntitiesDataContext(SPContext.Current.Web.Url)) { UserInfoItem user = null; user = dataContext.UserInfo.FirstOrDefault(i => i.Id ==Convert.ToInt32(tx_Del.Text)); dataContext.UserInfo.DeleteOnSubmit(user); dataContext.SubmitChanges(); } tx_Del.Text = ""; bt_SelectClick(sender, e); }
Query
Public void bt_selectclick (Object sender, eventargs e) {stringbuilder html = new stringbuilder (); iqueryable <userinfoitem> userlist = NULL; If (! String. isnullorempty (tb_username.text) {using (site9527entitiesdatacontext datacontext = new site9527entitiesdatacontext (spcontext. current. web. URL) {userlist = datacontext. userinfo. where (I => I. username. contains (tb_username.text) ;}} else {using (site9527entitiesdatacontext datacontext = new site9527entitiesdatacontext (spcontext. current. web. URL) {userlist = datacontext. userinfo; }} foreach (VAR user in userlist) {HTML. append ("<tr>"); html. append ("<TD>" + User. title); html. append ("</TD>"); html. append ("<TD>" + User. username); html. append ("</TD>"); html. append ("<TD>" + User. gender); html. append ("</TD>"); html. append ("<TD>" + User. tell); html. append ("</TD>"); html. append ("<TD>" + User. adress); html. append ("</TD>"); html. append ("<TD>" + User. approvalstatue); html. append ("</TD>"); html. append ("<TD>" + User. approvalby); html. append ("</TD>"); html. append ("<TD> <a id = 'A _ Update' onclick = 'Update (" + User. id. tostring () + ") '> Update </A> <a id = 'A _ delete' onclick = 'delete (" + User. id. tostring () + ") '> Delete </a>"); html. append ("</TD>"); html. append ("</tr>");} td_html.text = html. tostring ();}
Change
protected void bt_SaveClic(object sender, EventArgs e) { using (Site9527EntitiesDataContext dataContext = new Site9527EntitiesDataContext(SpContext.Current.Web.Url)) { UserInfoItem user = null; user = dataContext.UserInfo.FirstOrDefault(i => i.Id == Convert.ToInt32(Request.QueryString["ID"])); user.Title = this.tx_Title.Text; user.UserName = this.tx_UserName.Text; user.Adress = this.tx_adress.Text; user.Gender = this.tx_Gender.Text; user.Tell = this.tx_tell.Text; dataContext.SubmitChanges(user); } base.Response.Redirent("UserInfoList.aspx"); }