首页 > 代码库 > GridView编辑删除
GridView编辑删除
1 A前台代码 2 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="Maticsoft.Web.CarRentWeb.test" %> 3 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 4 5 6 <html xmlns="http://www.w3.org/1999/xhtml" > 7 <head runat="server"> 8 <title></title> 9 </head>10 <body>11 <form id="form1" runat="server">12 <div>13 14 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 15 onpageindexchanging="GridView1_PageIndexChanging" 16 onrowcancelingedit="GridView1_RowCancelingEdit" 17 DataKeyNames="ID"18 onrowdatabound="GridView1_RowDataBound" onrowdeleting="GridView1_RowDeleting" 19 onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating">20 21 <Columns> 22 23 <asp:TemplateField HeaderText="编号（或用户名）"> 24 <ItemTemplate>25 <asp:Label ID="Label1" runat="server" Text=‘<%# Eval("ID") %>‘></asp:Label>26 </ItemTemplate>27 </asp:TemplateField>28 <asp:TemplateField HeaderText="姓名">29 <EditItemTemplate>30 <asp:TextBox ID="tbxName" Width="70px" runat="server" Text=‘<%# Eval("sname") %>‘></asp:TextBox>31 </EditItemTemplate>32 <ItemTemplate>33 <asp:Label ID="Label2" runat="server"><%# Eval("sname") %></asp:Label>34 </ItemTemplate>35 </asp:TemplateField>36 <asp:TemplateField HeaderText="地址">37 38 39 <EditItemTemplate> 40 <asp:TextBox ID="tbxdizhi" Width="70px" runat="server" Text=‘<%# Eval("dizhi") %>‘></asp:TextBox>41 </EditItemTemplate>42 43 <ItemTemplate>44 <asp:Label ID="Label4" runat="server"><%# Eval("dizhi") %></asp:Label>45 </ItemTemplate>46 </asp:TemplateField> 47 48 49 <asp:CommandField ShowEditButton="True" HeaderText="编辑" />50 <asp:CommandField ShowDeleteButton="True" HeaderText="删除" />51 </Columns>52 <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />53 <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />54 <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />55 <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />56 <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />57 </asp:GridView>58 </div>59 </form>60 </body>61 </html>
B。后台代码using System;using System.Collections;using System.Configuration;using System.Data;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using BLL;using Model;using Maticsoft.Common;using System.Text.RegularExpressions;namespace Maticsoft.Web.CarRentWeb{ public partial class test : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { GridViewBind(); } } private void GridViewBind() { BLL.testBll kk = new Maticsoft.BLL.testBll(); DataSet ds = kk.getall(); GridView1.DataSource = ds.Tables[0];//为GridView控件指名数据源 GridView1.DataBind();//GridView控件绑定数据 } // protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; GridViewBind(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { int i; //执行循环，保证每条数据都可以更新 for (i = 0; i < GridView1.Rows.Count; i++) { //首先判断是否是数据行 if (e.Row.RowType == DataControlRowType.DataRow) { //当鼠标停留时更改背景色 e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor=‘Aqua‘"); //当鼠标移开时还原背景色 e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c"); } } } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; GridViewBind(); } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string userID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值 BLL.testBll kk = new Maticsoft.BLL.testBll(); Maticsoft.Model.testModel model = new Maticsoft.Model.testModel(); model.Id = Convert.ToInt32(userID); int k = kk.Del(model); if (k > 0)//根据主键使用DeleteByProc方法删除用户 { Response.Write("<script language=javascript>alert(‘删除成功!‘);location=‘test.aspx‘;</script>"); } else { Response.Write("<script language=javascript>alert(‘删除失败!‘);location=‘test.aspx‘;</script>"); } GridView1.EditIndex = -1; GridViewBind();//重新绑定数据 } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; //GridView编辑项索引等于单击行的索引 GridViewBind(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string userID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出记录的主键值 Maticsoft.Model.testModel model = new Maticsoft.Model.testModel(); model .Name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("tbxName")).Text; model.Id = Convert.ToInt32(userID); model.Dizhi = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("tbxdizhi")).Text; BLL.testBll kk = new Maticsoft.BLL.testBll(); int aa = kk.update(model); if (aa>0)//使用Usersmr类UpdateByProc方法修改用户信息 { GridViewBind(); Response.Write("<script language=javascript>alert(‘修改成功!‘);location=‘test.aspx‘;</script>"); } else { Response.Write("<script language=javascript>alert(‘修改成功!‘);location=‘test.aspx‘;</script>"); } GridView1.EditIndex = -1; GridViewBind(); } }}
1 C。sql语句 2 create table test 3 ( 4 id int primary key identity(1,1), 5 sname varchar(100), 6 dizhi varchar(100) 7 ) 8 go 9 insert into test values(‘张三‘,‘北京‘);10 insert into test values(‘李四‘,‘河北‘);
GridView编辑删除
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。