vwd 2008 express with acces - rowupdating

Question

needanswer 0 Light Poster

16 Years Ago

This program:

edit select delete id etc.

(outside under gridview)

textbox1
textbox2

addbutton cancelbutton

]
   <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
        AutoGenerateColumns="False" DataKeyNames="id"  
            BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" 
            CellPadding="3" GridLines="Vertical" >
            <RowStyle BackColor="#EEEEEE" ForeColor="Black"/>
            <Columns>
                <asp:TemplateField ShowHeader="False">
                    <EditItemTemplate>
                        <asp:Button ID="Button1" runat="server" CausesValidation="True" 
                            CommandName="Update" Text="Update" />
                        &nbsp;<asp:Button ID="Button2" runat="server" CausesValidation="False" 
                            CommandName="Cancel" Text="Cancel" />
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Button ID="Button1" runat="server" CausesValidation="False" 
                            CommandName="Edit" Text="Edit" />
                        &nbsp;<asp:Button ID="Button2" runat="server" CausesValidation="False" 
                            CommandName="Select" Text="Select" />
                        &nbsp;<asp:Button ID="Button3" runat="server" CausesValidation="False" 
                            CommandName="Delete" Text="Cancel" OnClientClick="return confirm('Are you sure');"/>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" Visible="False" />
                <asp:BoundField DataField="sysaccount" HeaderText="sysaccount" 
                    SortExpression="sysaccount" />
                <asp:BoundField DataField="syspw" HeaderText="syspw" SortExpression="syspw" />
                <asp:BoundField DataField="log" HeaderText="log" SortExpression="log" />
            </Columns>
            <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="#DCDCDC" />
        </asp:GridView>
    <br />
    <br />
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <br />
        <br />
&nbsp;&nbsp;&nbsp;
        <br />
        <br />
        <br />
        <br />
&nbsp;&nbsp;
        <asp:Label ID="Label3" runat="server" Text="System Manager"></asp:Label>
&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="TextBox1" runat="server" Height="26px"></asp:TextBox>
        <br />
        <br />
        <br />
&nbsp;&nbsp;
        <asp:Label ID="Label4" runat="server" Text="Password"></asp:Label>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="TextBox2" runat="server" Height="26px"></asp:TextBox>
&nbsp;<br />
        <br />
        <br />
        <br />
&nbsp;&nbsp;&nbsp;
        <asp:Button ID="Button4" runat="server" 
            style="font-size: large; font-family: Times New Roman; font-weight: 700" Text="Add" />
&nbsp;&nbsp;
        <asp:Button ID="Button5" runat="server" 
            style="font-size: large; font-family: Times New Roman; font-weight: 700" Text="Cancel" />
    &nbsp;

Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating
        Dim sqlupdate As String
        Dim con1 As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Users\user\Desktop\honor.mdb")
        sqlupdate = "UPDATE sysdep SET sysaccount= @sysaccount, syspw= @syspw WHERE id= @id"

        Dim cmd1 As New OleDbCommand(sqlupdate, con1)

        Dim id As String = (GridView1.Rows(e.RowIndex).Cells(0).ToString)

        Dim account As String = (GridView1.Rows(e.RowIndex).Cells(1).ToString)
        Dim pw As String = (GridView1.Rows(e.RowIndex).Cells(2).ToString)


        cmd1.Parameters.Add(New OleDbParameter("@sysaccount", account))
        cmd1.Parameters.Add(New OleDbParameter("@syspw", pw))
        cmd1.Parameters.Add(New OleDbParameter("@id", id))

        Try
            con1.Open()
            cmd1.ExecuteNonQuery()
        Catch ex As OleDbException
            MsgBox(ex.Message, MsgBoxStyle.Critical, "Web")
        Catch ex As InvalidOperationException
            MsgBox(ex.Message, MsgBoxStyle.Critical, "Web")
        Catch ex As Exception
            MsgBox(ex.Message, MsgBoxStyle.Critical, "Web")
        End Try

        con1.Close()

        GridView1.EditIndex = -1

        BindGridView()
    End Sub

I got all buttons working except the gridview1_rowupdating?

Thanks.

.net database-design

Edited 16 Years Ago by needanswer because: n/a

2 Contributors
2 Replies
122 Views
2 Days Discussion Span
Latest Post 16 Years Ago Latest Post by dnanetwork

Dani AI

Generated 9 Months Ago

Good — this thread shows a classic GridView editing pattern and the usual gotchas. Two short, practical points that tend to bite people (and what fixed it for after pointed it out):

Edit lifecycle and rebinding: the usual flow is RowEditing -> set the GridView EditIndex and rebind -> user edits -> RowUpdating -> perform DB update -> clear EditIndex (exit edit mode) -> rebind. If the grid is rebound on every PostBack (for example, calling BindGridView from Page_Load without wrapping it in If Not IsPostBack), the editing state and posted values get lost and RowUpdating will seem to do nothing. Restoring the EditIndex to exit edit mode and then rebinding is required to see the updated data.
How to read the new values reliably: do not depend on Cells(...).ToString (that returns type/metadata, not the edited textbox value) or on hidden cell indexes. Use the DataKeys collection for the row key and FindControl (or template fields with named controls) to get the TextBox values. Example pattern:

Dim id = GridView1.DataKeys(e.RowIndex).Value
Dim tb = CType(GridView1.Rows(e.RowIndex).FindControl("txtSysAccount"), TextBox)
Dim account = tb.Text

Extra tips:

With the OleDb provider, parameter binding is positional — either use ? placeholders or make sure parameters are added in the same order as the placeholders.
Use Using blocks for connection/command disposal and avoid server-side MsgBox in ASP.NET; log errors or surface them to the client with a Label or script.
If RowUpdating still does not fire, confirm the Update button has CommandName="Update" and the event is actually wired (OnRowUpdating or Handles clause).

These steps explain why setting the EditIndex back (what noted) works and give safer ways to fetch and persist the edited values.

All 2 Replies

dnanetwork 18 Practically a Master Poster

16 Years Ago

GridView1.EditIndex = -1
was the key i guess..!

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

needanswer 0 Light Poster · Answer 1 · 2010-06-11T07:49:33+00:00