I am trying to retrieve data from a user clicking on a datagrid
button but I am getting the following error:

Method 'Public Sub dgNewUsersOnItemCommand(s As Object, e As System.Web.UI.WebControls.DataListCommandEventArgs )' does not have the same signature as delegate 'Delegate Sub DataGridCommandEventHandler(source As Object, e As System.Web.UI.WebControls.DataGridCommandEventArgs )'.

The Markup looks like this:

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="testdatagrid.aspx.vb" Inherits="testsite.testdatagrid"%>

Head and body tags of course

<form id="Form1" method="post" runat="server">
 <asp:DataGrid id="dgNewUsers"OnItemCommand="dgNewUsersOnItemComm and"
  AutoGenerateColumns="False" BorderWidth="0" BorderStyle="None" runat="server">

            <AlternatingItemStyle BackColor="LightSteelBlue"/>
            <HeaderStyle Font-Bold="True" ForeColor="White" BackColor="LightSlateGray"/>

            <Columns>
                <asp:ButtonColumn Text="Approve Subscription"/>
                <asp:BoundColumn DataField="userid" HeaderText="ID"></asp:BoundColumn>
                <asp:BoundColumn DataField="username" HeaderText="User Name"></asp:BoundColumn>
                <asp:BoundColumn DataField="firstname" HeaderText="First Name"></asp:BoundColumn>
                <asp:BoundColumn DataField="middleinitial" HeaderText="Middle Initial"></asp:BoundColumn>
                <asp:BoundColumn DataField="lastname" HeaderText="Last Name"></asp:BoundColumn>
                <asp:BoundColumn DataField="levelidpicked" HeaderText="Level Picked"> </asp:BoundColumn>
                <asp:BoundColumn DataField="lastlogin" HeaderText="Last Login Date"></asp:BoundColumn>
                <asp:BoundColumn DataField="emailaddress" HeaderText="Email"></asp:BoundColumn>
            </Columns>

            </asp:DataGrid>
        </form>

The code that is in the aspx.vb file looks like this:

Imports System.Data.SqlClient

Public Class testdatagrid
    Inherits System.Web.UI.Page

    Dim con As New SqlConnection( connection string)


    Protected WithEvents dgNewUsers As System.Web.UI.WebControls.DataGrid

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        If Not IsPostBack Then
            getnewusers()
        End If
    End Sub

    Sub getnewusers()
        Dim cmd As New SqlCommand("exec sp_get_users 1", con)
        Dim da As New SqlDataAdapter
        Dim ds As New DataSet

        Try
            If con.State = ConnectionState.Open Then
                con.Close()
            End If

            da.SelectCommand = cmd
            da.Fill(ds)
            con.Close()
        Catch ex As Exception
            Throw ex
        End Try

        dgNewUsers.DataSource = ds
        dgNewUsers.DataBind()
    End Sub

    Sub dgNewUsersOnItemCommand(ByVal s As Object, ByVal e As DataListCommandEventArgs)
        Response.Write("Helpme")
    End Sub
End Class

When I put the sub dgNewUsersOnItemCommand on the markup page between the
<script language=vb runat=server></script> tags it works like a champ. But I cannot get this to run in the .vb file. I know I am missing something obvious.

TIA,
Cowa

When you have event handlers in the code behind, you need to specify what the handler "Handles". Note the "Handles MyBase.Load" on the Page_Load method.

Sub dgNewUsersOnItemCommand(ByVal s As Object, ByVal e As DataListCommandEventArgs) Handles dgNewUsers.ItemCommand

The keyword WithEvents permits this syntax. It makes the ASPX code much cleaner because you don't have to specify the handlers in the control's HTML (you should remove it from the <asp:DataGrid...> tag).

Peter

Also,

When you specify an event for a handler to handle (using "Handles ...", you'll get the pre-compile warns about your error. I think your actual error has to do with the function signature.

One thing that makes it VERY easy to set up these handlers is to look at the current document (under the document tabs). There you will find two drop downs. On the left you can choose what control you want to work with. Once you have a datagrid on the page and code-behind, you'll be able to choose it. Then in the right drop down, you can choose an even you want to set up a handler for. VS will draw the function with the correct signature to match the event delegate. Then you just need to add the guts of the method.

Peter

:D Thanks planoie!! That worked like a champ.