Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

VB.net error Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 5:09 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 4:09 AM
Points: 580, Visits: 1,839
Hi,

I get this error when I build my code:

"Handles clause requires a WithEvents variable defined in the containing type or one of its base types."

Please find my code below (the error line is in bold):

-------------------------------------
Public Class _Default
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

End Sub

Protected Sub GridView1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles GridView1.SelectedIndexChanged

End Sub
End Class
-------------------------------------

Thanks,
Paul
Post #1407760
Posted Wednesday, January 16, 2013 5:22 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:39 PM
Points: 1,805, Visits: 5,874
And do you actually have a component on the page called GridView1?

MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1407769
    Posted Wednesday, January 16, 2013 5:31 AM


    SSCrazy

    SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

    Group: General Forum Members
    Last Login: Wednesday, November 26, 2014 1:28 PM
    Points: 2,386, Visits: 7,611
    It has been awhile since I've done any VB.net, but don't you need a WithEvents variable?

    e.g.
    Dim WithEvents ev As New EventClass

    Sub TestEvents()
    ev.RaiseEvents()
    End Sub

    Sub ev_EventHandler() Handles ev.XEvent, ev.YEvent
    MsgBox("Received Event.")
    End Sub


    --EDIT--

    Also, I take it you've had a look at the Microsoft tutorial?

    <%@ Page language="VB" %>

    <script runat="server">

    Sub CustomersGridView_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)

    ' Get the currently selected row using the SelectedRow property.
    Dim row As GridViewRow = CustomersGridView.SelectedRow

    ' Display the company name from the selected row.
    ' In this example, the third column (index 2) contains
    ' the company name.
    Message.Text = "You selected " & row.Cells(2).Text & "."

    End Sub

    Sub CustomersGridView_SelectedIndexChanging(ByVal sender As Object, ByVal e As GridViewSelectEventArgs)

    ' Get the currently selected row. Because the SelectedIndexChanging event
    ' occurs before the select operation in the GridView control, the
    ' SelectedRow property cannot be used. Instead, use the Rows collection
    ' and the NewSelectedIndex property of the e argument passed to this
    ' event handler.
    Dim row As GridViewRow = CustomersGridView.Rows(e.NewSelectedIndex)

    ' You can cancel the select operation by using the Cancel
    ' property. For this example, if the user selects a customer with
    ' the ID "ANATR", the select operation is canceled and an error message
    ' is displayed.
    If row.Cells(1).Text = "ANATR" Then

    e.Cancel = True
    Message.Text = "You cannot select " + row.Cells(2).Text & "."

    End If

    End Sub

    </script>

    <html>
    <body>
    <form runat="server">

    <h3>GridView Select Example</h3>

    <asp:gridview id="CustomersGridView"
    datasourceid="CustomersSource"
    autogeneratecolumns="true"
    autogenerateselectbutton="true"
    allowpaging="true"
    selectedindex="0"
    onselectedindexchanged="CustomersGridView_SelectedIndexChanged"
    onselectedindexchanging="CustomersGridView_SelectedIndexChanging"
    runat="server">

    <selectedrowstyle backcolor="LightCyan"
    forecolor="DarkBlue"
    font-bold="true"/>

    </asp:gridview>

    <br/>

    <asp:label id="Message"
    forecolor="Red"
    runat="server"/>

    <!-- This example uses Microsoft SQL Server and connects -->
    <!-- to the Northwind sample database. Use an ASP.NET -->
    <!-- expression to retrieve the connection string value -->
    <!-- from the Web.config file. -->
    <asp:sqldatasource id="CustomersSource"
    selectcommand="Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"
    connectionstring="<%$ ConnectionStrings:NorthWindConnectionString%>"
    runat="server"/>

    </form>
    </body>
    </html>




    Not a DBA, just trying to learn

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better, quicker answers on SQL Server performance related questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/



    If you litter your database queries with nolock query hints, are you aware of the side effects?
    Try reading a few of these links...

    (*) Missing rows with nolock
    (*) Allocation order scans with nolock
    (*) Consistency issues with nolock
    (*) Transient Corruption Errors in SQL Server error log caused by nolock
    (*) Dirty reads, read errors, reading rows twice and missing rows with nolock


    LinkedIn | Blog coming soon (for sufficiently large values of "soon" )!
    Post #1407775
    Posted Wednesday, January 16, 2013 5:35 AM
    Mr or Mrs. 500

    Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

    Group: General Forum Members
    Last Login: Tuesday, November 18, 2014 4:09 AM
    Points: 580, Visits: 1,839
    blank
    Post #1407777
    Posted Wednesday, January 16, 2013 5:36 AM
    Mr or Mrs. 500

    Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

    Group: General Forum Members
    Last Login: Tuesday, November 18, 2014 4:09 AM
    Points: 580, Visits: 1,839
    mister.magoo (1/16/2013)
    And do you actually have a component on the page called GridView1?


    Thanks a lot for your help, I renamed the dropdownlist as GridView1 and it worked !
    Post #1407778
    Posted Wednesday, January 16, 2013 5:41 AM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Yesterday @ 5:39 PM
    Points: 1,805, Visits: 5,874
    pwalter83 (1/16/2013)
    mister.magoo (1/16/2013)
    And do you actually have a component on the page called GridView1?


    Thanks a lot for your help, I renamed the dropdownlist as GridView1 and it worked !


    That's nice, but for your sake and others who follow you, I would change the drop down list name to something more meaningful and then modify the code to correctly reference the drop down list name...GridView1 isn't really a good name for a drop down list now is it?


    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1407783
    Posted Wednesday, January 16, 2013 7:59 AM
    Mr or Mrs. 500

    Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

    Group: General Forum Members
    Last Login: Tuesday, November 18, 2014 4:09 AM
    Points: 580, Visits: 1,839
    mister.magoo (1/16/2013)
    pwalter83 (1/16/2013)
    mister.magoo (1/16/2013)
    And do you actually have a component on the page called GridView1?


    Thanks a lot for your help, I renamed the dropdownlist as GridView1 and it worked !


    That's nice, but for your sake and others who follow you, I would change the drop down list name to something more meaningful and then modify the code to correctly reference the drop down list name...GridView1 isn't really a good name for a drop down list now is it?


    Actually I have changed the name to a more meaningful now. Thanks again !
    Post #1407847
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse