通过vb.net中的gridview更新数据库 [英] updating database through gridview in vb.net

问题描述

这是我的更新事件代码

Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating
    Connection.Open()
    Dim idd As Integer
    idd = GridView1.DataKeys(e.RowIndex).Value
    Dim empname As TextBox
    Dim a As String
    empname = GridView1.Rows(e.RowIndex).FindControl("empName")
    a = Trim(empname.Text.ToString)
    Dim Command As New OleDbCommand("update employeeDetails set empName='" & a & "' where ID=" & Trim(idd) & " ", Connection)
    Command.ExecuteNonQuery()
    Connection.Close()
    GridView1.EditIndex = -1
    Response.Redirect("listOfAssociates.aspx")
End Sub

而我的gridview代码是:

and my gridview code is:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID">
        <Columns>
            <asp:TemplateField HeaderText="S NO"></asp:TemplateField>
            <asp:BoundField HeaderText="Emp Id" DataField="empNumber"/>
            <asp:BoundField HeaderText="Emp Name" DataField="empName"/>
            <asp:BoundField HeaderText="Emp Email Id" DataField="empEmailId"/>
            <asp:BoundField HeaderText="Role" DataField="empRole"/>
            <asp:BoundField HeaderText="Project Won" DataField="empProjectNumber"/>
            <asp:BoundField HeaderText="Project Name" DataField="empProjectName"/>
            <asp:BoundField HeaderText="Start Date" DataField="empProjectStartDate"/>
            <asp:BoundField HeaderText="End Date" DataField="empProjectEndDate"/>
            <asp:BoundField HeaderText="Supervisor Id" DataField="empProjectSupervisorId"/>
            <asp:BoundField HeaderText="Allocation %" DataField="empProjectAP"/>
            <asp:CommandField ShowEditButton="True" />
            <asp:CommandField ShowDeleteButton="True" />

        </Columns>
    </asp:GridView>

它正在删除并正常运行，但是在尝试更新时显示此行中的用户代码未处理nullreferenceexception:

it is deleting and fetching fine but while trying to update it shows nullreferenceexception was unhandled by user code in this line:

a =修剪(empname.Text.ToString)

a = Trim(empname.Text.ToString)

谁能帮助我.预先感谢

使用ms访问权限作为数据库

using ms access as database

推荐答案

尝试一下...

'intRowIndex = Integer Variable of Row you wish to retrieve values from.
a = Trim(gridview1.rows(intRowIndex).Cells(2).Text)

这篇关于通过vb.net中的gridview更新数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！