在平时的实际项目中,为了减少往返提交数据,可以一次编辑 GridView 的所有行,这样大大提高用户使用产品的体验。下面就讲解何一次编辑 GridView 的所有数据行。在下面的例子中,数据库使用《ASP.NET 2.0应用开发技术》一书中Site\App_Data\下的 ASPNET20Book.mdb 数据库。例子中的数据更新方式使用 SqlDataSource 数据源控件的UpdateCommand属性,但此方法同样适用于存储过程,SQL 语句等。
在平时的实际项目中,为了减少往返提交数据,可以一次编辑 GridView 的所有行,这样大大提高用户使用产品的体验。下面就讲解何一次编辑 GridView 的所有数据行。在下面的例子中,数据库使用《ASP.NET 2.0应用开发技术》一书中Site\App_Data\下的 ASPNET20Book.mdb 数据库。例子中的数据更新方式使用 SqlDataSource 数据源控件的UpdateCommand属性,但此方法同样适用于存储过程,SQL 语句等。
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default7.aspx.cs" Inherits="Default7" %>
![](/Images/OutliningIndicators/None.gif)
<!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" Font-Size="12px" CellPadding="3" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound"
OnRowCreated="GridView1_RowCreated">
<HeaderStyle BackColor="#EDEDED" />
<Columns>
<asp:TemplateField HeaderText="姓名">
<ItemTemplate>
<asp:TextBox ID="txtTitle" runat="server" Text='<%#Eval("Title") %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="性别">
<ItemTemplate>
<asp:RadioButtonList ID="txtGender" runat="server" RepeatColumns="2">
<asp:ListItem Text='男'></asp:ListItem>
<asp:ListItem Text='女'></asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="学历">
<ItemTemplate>
<asp:DropDownList ID="txtClassName" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Persist Security Info=False;User ID=sa;Password=;Initial Catalog=Book;Server=."
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Student]"
UpdateCommand="Update [Student] Set Title = @Title,Gender = @Gender,ClassName=@ClassName Where id=@id">
</asp:SqlDataSource>
<asp:Button ID="Button1" runat="server" Text="保存所有修改" OnClick="XianhuiMeng_Click" />
</div>
</form>
</body>
</html>
![](/Images/OutliningIndicators/None.gif)
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
![](/Images/OutliningIndicators/None.gif)
public partial class Default7 : System.Web.UI.Page
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
protected void Page_Load(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/InBlock.gif)
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
string[] ClassNameArray =
{ "大学", "中学", "高中" };
![](/Images/OutliningIndicators/InBlock.gif)
//初始化原来的值
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (e.Row.RowType == DataControlRowType.DataRow)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
System.Data.DataRowView drv = (System.Data.DataRowView)e.Row.DataItem;
RadioButtonList rbl = (RadioButtonList)e.Row.FindControl("txtGender");
if (rbl != null)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if ((bool)drv["Gender"])
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
rbl.Items.FindByText("男").Selected = true;
}
else
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
rbl.Items.FindByText("女").Selected = true;
}
}
![](/Images/OutliningIndicators/InBlock.gif)
DropDownList ddl = (DropDownList)e.Row.FindControl("txtClassName");
if (ddl != null)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
ddl.Items.FindByText(drv["ClassName"].ToString()).Selected = true;
}
}
}
![](/Images/OutliningIndicators/InBlock.gif)
// 初始化项目列表
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (e.Row.RowType == DataControlRowType.DataRow)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
DropDownList ddl = (DropDownList)e.Row.FindControl("txtClassName");
ddl.DataSource = ClassNameArray;
ddl.DataBind();
}
}
![](/Images/OutliningIndicators/InBlock.gif)
//处理提交的数据
protected void XianhuiMeng_Click(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
foreach (GridViewRow gvr in GridView1.Rows)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string tGender = ((RadioButtonList)gvr.FindControl("txtGender")).SelectedValue;
SqlDataSource1.UpdateParameters.Add(new Parameter("Title", TypeCode.String, ((TextBox)gvr.FindControl("txtTitle")).Text));
SqlDataSource1.UpdateParameters.Add(new Parameter("Gender", TypeCode.Boolean, (tGender == "男" ? "True" : "False")));
SqlDataSource1.UpdateParameters.Add(new Parameter("ClassName",
TypeCode.String, ((DropDownList)gvr.FindControl("txtClassName")).SelectedValue));
SqlDataSource1.UpdateParameters.Add(new Parameter("id", TypeCode.Int32, GridView1.DataKeys[gvr.DataItemIndex].Value.ToString()));
SqlDataSource1.Update();
SqlDataSource1.UpdateParameters.Clear();
}
Response.Redirect(Request.UrlReferrer.ToString());
}
![](/Images/OutliningIndicators/InBlock.gif)
}
![](/Images/OutliningIndicators/None.gif)