2022年gridview编辑和删除实现其功能 .pdf

《2022年gridview编辑和删除实现其功能 .pdf》由会员分享，可在线阅读，更多相关《2022年gridview编辑和删除实现其功能 .pdf（6页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、效果图：用 做网上讲了很多直接绑定数据库的我这里就不用那方法了。新建一个文件夹叫Data 的用来存储数据下面就是前台的代码：用户管理 名师资料总结-精品资料欢迎下载-名师精心整理-第 1 页，共 6 页 -asp:TextBoxID=txtTelephoneText=runat=serverWidth=100px/asp:TextBoxID=txtEmailText=runat=serverWidth=140px/asp:HiddenFieldID=hdfDepartmentIdrunat=serverValue=/名师资料总结-精品资料欢迎下载-名师精心整理-第 2 页，共 6 页 -下面是

2、后天运行的代码：using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;namespace OrderFood.Views.Admin publicpartialclassUserManage :System.Web.UI.Page protectedvoid Page_Load(object sender,EventArgs e)if (!IsPostBack)GridViewBind

3、();privatevoid GridViewBind()GridView1.DataSource=DataStore.OrderFoodDataContext.UserInfo.ToList();GridView1.DataBind();名师资料总结-精品资料欢迎下载-名师精心整理-第 3 页，共 6 页 -/增加用户/protectedvoid btnAdd_Click(object sender,EventArgs e)Response.Redirect(EditUserForm.aspx);protectedvoid GridView1_PageIndexChanging(object

4、 sender,GridViewPageEventArgse)GridView1.PageIndex=e.NewPageIndex;GridViewBind();protectedvoid GridView1_RowDataBound(object sender,GridViewRowEventArgs e)if (DropDownList)e.Row.FindControl(ddlDepartments)!=null)DropDownListddlDepartments=(DropDownList)e.Row.FindControl(ddlDepartments);/生成 DropDownL

5、ist 的值，绑定数据 ddlDepartments.DataSource=DataStore.OrderFoodDataContext.Department;ddlDepartments.DataTextField=DepartmentName;ddlDepartments.DataValueField=DepartmentId;ddlDepartments.DataBind();/选中 DropDownList ddlDepartments.SelectedValue=(HiddenField)e.Row.FindControl(hdfDepartmentId).Value;/Label

6、labelDepartment=(Label)e.Row.FindControl(labelDepartment);/labelDepartment.Text=(Data.UserInfo)e.Row.DataItem).Department.DepartmentName;protectedvoid GridView1_RowEditing(object sender,GridViewEditEventArgs e)名师资料总结-精品资料欢迎下载-名师精心整理-第 4 页，共 6 页 -GridView1.EditIndex=e.NewEditIndex;GridViewBind();prot

7、ectedvoidGridView1_RowCancelingEdit(objectsender,GridViewCancelEditEventArgs e)GridView1.EditIndex=-1;GridViewBind();protectedvoid GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)string userId=GridView1.DataKeyse.RowIndex.Values0.ToString();stringtelephone=(TextBox)GridView1.Rowse.RowI

8、ndex.FindControl(txtTelephone).Text;stringemail=(TextBox)GridView1.Rowse.RowIndex.FindControl(txtEmail).Text;stringdepartmentId=(DropDownList)GridView1.Rowse.RowIndex.FindControl(ddlDepartments).SelectedValue;varfirst=DataStore.OrderFoodDataContext.UserInfo.FirstOrDefault(p=p.UserId=userId);if (firs

9、t!=null)first.Telephone=telephone;first.Email=email;first.DepartmentId=Convert.ToInt32(departmentId);DataStore.OrderFoodDataContext.SubmitChanges();GridView1.EditIndex=-1;GridViewBind();protectedvoid GridView1_RowDeleting(object sender,GridViewDeleteEventArgs e)string userId=GridView1.DataKeyse.RowI

10、ndex.Values0.ToString();if (userId=admin)Helpers.HtmlHelper.Show(this,管理员用户禁止删除!);return;名师资料总结-精品资料欢迎下载-名师精心整理-第 5 页，共 6 页 -varfirst=DataStore.OrderFoodDataContext.UserInfo.FirstOrDefault(p=p.UserId=userId);if (first!=null)DataStore.OrderFoodDataContext.UserInfo.DeleteOnSubmit(first);DataStore.OrderFoodDataContext.SubmitChanges();GridView1.EditIndex=-1;GridViewBind();publicstring DepartmentIdToNameConverter(object id)returnDataStore.OrderFoodDataContext.Department.FirstOrDefault(p=p.DepartmentId=(int)id).DepartmentName;希望能帮到需要的。一起加油！名师资料总结-精品资料欢迎下载-名师精心整理-第 6 页，共 6 页 -