ASP.NET VB中GridView更新SQL数据时找不到TextBox控件问题

核心问题分析 #

你的代码存在两个关键问题：

1. 控件定位逻辑缺失：GridView编辑行的TextBox通常嵌套在EditItemTemplate模板容器中，直接用row.FindControl可能因容器层级问题无法定位；此外需确保前端模板中控件ID与后台代码完全匹配。
2. 参数传递错误：你直接将TextBox控件对象传给SQL参数，正确做法应取TextBox.Text属性值。

解决步骤 #

1. 验证前端GridView模板定义 #

确保编辑模式下的TextBox位于EditItemTemplate中，且ID与后台代码一致：

<asp:GridView ID="GridView1" runat="server" 
              OnRowUpdating="GridView1_RowUpdating" 
              AutoGenerateEditButton="True"
              DataKeyNames="ID"> <!-- 必须设置主键列，用于后续UPDATE的WHERE条件 -->
    <Columns>
        <asp:TemplateField HeaderText="VRM型号">
            <ItemTemplate>
                <asp:Label ID="lblVRMModel" runat="server" Text='<%# Eval("VRMModel") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="VRMModel" runat="server" Text='<%# Bind("VRMModel") %>'></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="组件缺陷">
            <ItemTemplate>
                <asp:Label ID="lblComponentDefect" runat="server" Text='<%# Eval("ComponentDefect") %>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="ComponentDefect" runat="server" Text='<%# Bind("ComponentDefect") %>'></asp:TextBox>
            </EditItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

2. 修复后台控件查找逻辑 #

若控件嵌套在模板容器中，可通过单元格索引定位，或使用递归查找适配多层嵌套场景：

' 方法1：通过单元格索引直接查找（需对应列的位置）
Dim row As GridViewRow = GridView1.Rows(e.RowIndex)
Dim VRMModel As TextBox = CType(row.Cells(0).FindControl("VRMModel"), TextBox)
Dim ComponentDefect As TextBox = CType(row.Cells(1).FindControl("ComponentDefect"), TextBox)

' 方法2：递归查找控件（通用方案，适配任意嵌套层级）
Private Function FindControlRecursive(ByVal root As Control, ByVal id As String) As Control
    If root.ID = id Then Return root
    For Each c As Control In root.Controls
        Dim foundControl As Control = FindControlRecursive(c, id)
        If foundControl IsNot Nothing Then Return foundControl
    Next
    Return Nothing
End Function

' 调用递归查找
Dim VRMModel As TextBox = CType(FindControlRecursive(row, "VRMModel"), TextBox)
Dim ComponentDefect As TextBox = CType(FindControlRecursive(row, "ComponentDefect"), TextBox)

3. 修正SQL参数传递与UPDATE语句 #

必须传递TextBox的Text属性值，同时补充WHERE条件避免全表更新：

Dim connectionString As String = ConfigurationManager.ConnectionStrings("VRM_Test").ConnectionString
Using connection As New SqlConnection(connectionString)
    ' 添加WHERE条件，通过DataKeys获取主键值
    Using command As New SqlCommand("UPDATE tblVRMModel SET VRMModel = @VRMModel, ComponentDefect = @ComponentDefect WHERE ID = @ID", connection)
        command.Parameters.AddWithValue("@ID", GridView1.DataKeys(e.RowIndex).Value)
        command.Parameters.AddWithValue("@VRMModel", VRMModel.Text.Trim())
        command.Parameters.AddWithValue("@ComponentDefect", ComponentDefect.Text.Trim())
        connection.Open()
        command.ExecuteNonQuery()
    End Using
End Using

4. 确保数据绑定时机正确 #

在Page_Load中仅首次加载时绑定GridView，避免回发时重置编辑状态：

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        BindGrid()
    End If
End Sub

内容的提问来源于stack exchange，提问作者aarjaang