在平时的实际项目中,为了减少往返提交数据,可以一次编辑 GridView 的所有行,这样大大提高用户使用产品的体验。下面就讲解何一次编辑 GridView 的所有数据行。在下面的例子中,数据库使用《ASP.NET 2.0应用开发技术》一书中Site/App_Data/下的 ASPNET20Book.mdb 数据库。例子中的数据更新方式使用 SqlDataSource 数据源控件的UpdateCommand属性,但此方法同样适用于存储过程,SQL 语句等。
<%
@ Page Language
=
"
C#
"
Debug
=
"
true
"
%>
<!
DOCTYPE html PUBLIC
"
-//W3C//DTD XHTML 1.0 Transitional//EN
"
"
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
"
>
<
script runat
=
"
server
"
>
string
[] ClassNameArray
=
...
{ " 大学 " , " 中学 " , " 高中 " }
;
//
初始化原来的值
protected
void
GridView1_RowDataBound(
object
sender, GridViewRowEventArgs e)
...
{ if (e.Row.RowType == DataControlRowType.DataRow) ... { System.Data.DataRowView drv = (System.Data.DataRowView)e.Row.DataItem; RadioButtonList rbl = (RadioButtonList)e.Row.FindControl( " txtGender " ); if (rbl != null ) ... { if (( bool )drv[ " Gender " ]) ... { rbl.Items.FindByText( " 男 " ).Selected = true ; } else ... { rbl.Items.FindByText( " 女 " ).Selected = true ; } } DropDownList ddl = (DropDownList)e.Row.FindControl( " txtClassName " ); if (ddl != null ) ... { ddl.Items.FindByText(drv[ " ClassName " ].ToString()).Selected = true ; } } }
//
初始化项目列表
protected
void
GridView1_RowCreated(
object
sender, GridViewRowEventArgs e)
...
{ if (e.Row.RowType == DataControlRowType.DataRow) ... { DropDownList ddl = (DropDownList)e.Row.FindControl( " txtClassName " ); ddl.DataSource = ClassNameArray; ddl.DataBind(); } }
//
处理提交的数据
protected
void
XianhuiMeng_Click(
object
sender, EventArgs e)
...
{ foreach (GridViewRow gvr in GridView1.Rows) ... { 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()); }
</
script
>
<
html xmlns
=
"
http://www.w3.org/1999/xhtml
"
>
<
head id
=
"
Head1
"
runat
=
"
server
"
>
<
title
>
同时编辑 GridView的 多行
</
title
>
</
head
>
<
body
>
<
form id
=
"
form1
"
runat
=
"
server
"
>
<
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
=
"
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|ASPNET20Book.mdb;Persist Security Info=True
"
ProviderName
=
"
System.Data.OleDb
"
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
"
/>
</
form
>
</
body
>
</
html
>
注意:对于SQL Server 数据库,参数名字不加@。另外注意:不同数据库类型和不同的数据源,UpdateCommand="Update [Student] Set Title = @Title,Gender = @Gender,ClassName=@ClassName Where id=@id"写法和SqlDataSource1.UpdateParameters.Add(new Parameter("@Title", TypeCode.String, ((TextBox)gvr.FindControl("txtTitle")).Text)); 的写法会有所区别。
SQL Server版本
<%
@ Page Language
=
"
C#
"
Debug
=
"
true
"
%>
<!
DOCTYPE html PUBLIC
"
-//W3C//DTD XHTML 1.0 Transitional//EN
"
"
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
"
>
<
script runat
=
"
server
"
>
string
[] ClassNameArray
=
...
{ " 大学 " , " 中学 " , " 高中 " }
;
//
初始化原来的值
protected
void
GridView1_RowDataBound(
object
sender, GridViewRowEventArgs e)
...
{ if (e.Row.RowType == DataControlRowType.DataRow) ... { System.Data.DataRowView drv = (System.Data.DataRowView)e.Row.DataItem; RadioButtonList rbl = (RadioButtonList)e.Row.FindControl( " txtGender " ); if (rbl != null ) ... { if (( bool )drv[ " Gender " ]) ... { rbl.Items.FindByText( " 男 " ).Selected = true ; } else ... { rbl.Items.FindByText( " 女 " ).Selected = true ; } } DropDownList ddl = (DropDownList)e.Row.FindControl( " txtClassName " ); if (ddl != null ) ... { ddl.Items.FindByText(drv[ " ClassName " ].ToString()).Selected = true ; } } }
//
初始化项目列表
protected
void
GridView1_RowCreated(
object
sender, GridViewRowEventArgs e)
...
{ if (e.Row.RowType == DataControlRowType.DataRow) ... { DropDownList ddl = (DropDownList)e.Row.FindControl( " txtClassName " ); ddl.DataSource = ClassNameArray; ddl.DataBind(); } }
//
处理提交的数据
protected
void
XianhuiMeng_Click(
object
sender, EventArgs e)
...
{ foreach (GridViewRow gvr in GridView1.Rows) ... { 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()); }
</
script
>
<
html xmlns
=
"
http://www.w3.org/1999/xhtml
"
>
<
head id
=
"
Head1
"
runat
=
"
server
"
>
<
title
>
同时编辑 GridView的 多行
</
title
>
</
head
>
<
body
>
<
form id
=
"
form1
"
runat
=
"
server
"
>
<
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
"
/>
</
form
>
</
body
>
</
html
>