<%
@ 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 >
<! 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 >
<%
@ 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 >
<! 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 >