ASP.NET GridView多行编辑-优快云博客

本文链接：https://blog.youkuaiyun.com/logenliqiang/article/details/4519395

初始化原来的值
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim drv As System.Data.DataRowView = DirectCast(e.Row.DataItem, System.Data.DataRowView)
        Dim rbl As RadioButtonList = DirectCast(e.Row.FindControl("txtGender"), RadioButtonList)
        If rbl IsNot Nothing Then
            If CBool(drv("Gender")) Then
                rbl.Items.FindByText("男").Selected = True
            Else
                rbl.Items.FindByText("女").Selected = True
            End If
        End If

        Dim ddl As DropDownList = DirectCast(e.Row.FindControl("txtClassName"), DropDownList)
        If ddl IsNot Nothing Then
            ddl.Items.FindByText(drv("ClassName").ToString()).Selected = True
        End If
    End If
End Sub

' 初始化项目列表
Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim ddl As DropDownList = DirectCast(e.Row.FindControl("txtClassName"), DropDownList)
        ddl.DataSource = ClassNameArray
        ddl.DataBind()
    End If
End Sub

'处理提交的数据
Protected Sub XianhuiMeng_Click(ByVal sender As Object, ByVal e As EventArgs)
    For Each gvr As GridViewRow In GridView1.Rows
        Dim tGender As String = DirectCast(gvr.FindControl("txtGender"), RadioButtonList).SelectedValue
        SqlDataSource1.UpdateParameters.Add(New Parameter("@Title", TypeCode.[String], DirectCast(gvr.FindControl("txtTitle"), TextBox).Text))
        SqlDataSource1.UpdateParameters.Add(New Parameter("@Gender", TypeCode.[Boolean], (If(tGender = "男", "True", "False"))))
        SqlDataSource1.UpdateParameters.Add(New Parameter("@ClassName", TypeCode.[String], DirectCast(gvr.FindControl("txtClassName"), DropDownList).SelectedValue))
        SqlDataSource1.UpdateParameters.Add(New Parameter("@id", TypeCode.Int32, GridView1.DataKeys(gvr.DataItemIndex).Value.ToString()))
        SqlDataSource1.Update()
        SqlDataSource1.UpdateParameters.Clear()
    Next
    Response.Redirect(Request.UrlReferrer.ToString())
End Sub

-------------------------html------------------------

<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>