gridview数据增删改查（当前行操作）

来源：互联网发布：宣美身材分析知乎编辑：程序博客网时间：2024/06/08 06:16

A前台代码

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="Maticsoft.Web.CarRentWeb.test" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
onpageindexchanging="GridView1_PageIndexChanging"
onrowcancelingedit="GridView1_RowCancelingEdit"
DataKeyNames="ID"
onrowdatabound="GridView1_RowDataBound" onrowdeleting="GridView1_RowDeleting"
onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating">

<Columns>

<asp:TemplateField HeaderText="编号（或用户名）">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("ID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="姓名">
<EditItemTemplate>
<asp:TextBox ID="tbxName" Width="70px" runat="server" Text='<%# Eval("sname") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server"><%# Eval("sname") %></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="地址">

<EditItemTemplate>
<asp:TextBox ID="tbxdizhi" Width="70px" runat="server" Text='<%# Eval("dizhi") %>'></asp:TextBox>
</EditItemTemplate>

<ItemTemplate>
<asp:Label ID="Label4" runat="server"><%# Eval("dizhi") %></asp:Label>
</ItemTemplate>
</asp:TemplateField>


<asp:CommandField ShowEditButton="True" HeaderText="编辑" />
<asp:CommandField ShowDeleteButton="True" HeaderText="删除" />
</Columns>
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
</asp:GridView>
</div>
</form>
</body>
</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();
}
}
}

C。sql语句

create table test
(
id int primary key identity(1,1),
sname varchar(100),
dizhi varchar(100)
)
go
insert into test values('张三','北京');
insert into test values('李四','河北');