does not have the same signature as delegate vb.net asp.net 2.0

[gtjr92]

This is for an asp.net 2.0 site, but I think the VB should be similiar.
I am using an access datasource, I set up a sub update db that checks the textboxes and updateds the Database. Basically I want a fully editable Gridview. i think Sqlcommandevent args is what i need I believe sql and access share some properties. Here is my error, my code is below that. I understand(i think) why i am getting the error but I am not sure how to correct it.

BC30408: Method 'Public Sub Updatedb(sender As Object, e As System.Web.UI.WebControls.SqlDataSourceCommandEven tArgs)' does not have the same signature as delegate 'Delegate Sub EventHandler(sender As Object, e As System.EventArgs)'.

Source Error:
Line 126: <div style="z-index: 103; left: 307px; width: 65px; position: absolute; top: 653px;
Line 127: height: 28px">
Line 128: <asp:Button ID="Button1" runat="server" Text="Update Tithe" OnClick=Updatedb /></div>
Line 129: <%-- <asp:AccessDataSource ID="Titheupdate" runat="server" DataFile="~/App_Data/tithe/GBCTITHE.MDB"
Line 130: UpdateCommand="UPDATE [Tithe] SET [WkID] = ?, [People_ID] = ?, [Tithe] = ?, [Education] = ?, [Special] = ?, [Missions] = ?, [Gift_Item] = ?, [Gift_Value] = ? WHERE [TRID] = ?">

Sub Updatedb(ByVal sender As Object, ByVal e As SqlDataSourceCommandEventArgs)
 
Dim dgi As GridViewRow
 
For Each dgi In GridView1.Rows
 
'Read in the Primary Key Field
 
Dim id As Integer = (GridView1.DataKeys(dgi.RowIndex).Value.ToString()  )
 
Dim Titheup As Decimal = CType(dgi.FindControl("TxtTithe"), TextBox).Text
 
 
e.Command.Parameters("@Titheup").Value = e.Command.Parameters("@TitheParam").Value
 
e.Command.Parameters("@id").Value = e.Command.Parameters("@Tridparam").Value
 
e.Command.Parameters.Remove(e.Command.Parameters("@TitheParam"))
 
e.Command.Parameters.Remove(e.Command.Parameters("@ID"))
 
dsoTithe.Update()
 
Next
End Sub

'I tried it this way too..
'Same type of error for this too

Sub Updatedb(ByVal sender As Object, ByVal e As AccessDataSourceView)
 
Dim dgi As GridViewRow
 
For Each dgi In GridView1.Rows
 
'Read in the Primary Key Field
 
Dim id As Integer = (GridView1.DataKeys(dgi.RowIndex).Value.ToString()  )
 
Dim Titheup As Decimal = CType(dgi.FindControl("TxtTithe"), TextBox).Text
 
'e.UpdateParameters.
 
e.UpdateParameters("@Titheup") = e.UpdateParameters("@TitheParam")
 
e.UpdateParameters("@id") = e.UpdateParameters("@Tridparam")
 
e.UpdateParameters.Clear()
 
dsoTithe.Update()

 

[PlausiblyDamp]

A button click has the event signature

Delegate Sub EventHandler(sender As Object, e As System.EventArgs)

i.e. it accepts 2 parameters. The first being an object and the second of type System.EventArgs. You are trying to assign a method with a different signature

Sub Updatedb(ByVal sender As Object, ByVal e As AccessDataSourceView)

to this event handler - hence the error message. The buton click event has no idea what a AccessDataSourceView or a SqlDataSourceCommandEventArgs is.

In your code where are the SqlDataSourceCommandEventArgs / AccessDataSourceView objects being created / updated?

 

[gtjr92]

Re:

In your code where are the SqlDataSourceCommandEventArgs / AccessDataSourceView objects being created / updated?

that is here

 <form id="form2" runat="server">
    <div>
        <asp:AccessDataSource ID="dsoTithe" runat="server"   DataFile="~/App_Data/tithe/GBCTITHE.MDB"
            SelectCommand="SELECT [Weeks_Date], [People_ID], [Name], 
[Tithe], [Education], [Missions], [Special], [Gift_Item], [Gift_Value], [WkID], 
[TRID] FROM [tithe] WHERE ([WkID] = ?)"
            UpdateCommand="UPDATE [Tithe] SET [Tithe]=? Where [trid]=?">
          <UpdateParameters>
          <asp:Parameter Name="Titheparam" Type="Decimal" />
          <asp:Parameter Name="Tridparam" Type="Int32" />
          </UpdateParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="lbxWeeks" DefaultValue="1" Name="WkID" PropertyName="SelectedValue"
                    Type="Double" />
            </SelectParameters>
            
           </asp:AccessDataSource>