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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 30, 2015 8:23 AM
Points: 615, Visits: 1,985
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:02 PM
Points: 1,980, Visits: 6,690
And do you actually have a component on the page called GridView1?

MM


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);


  • 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: Yesterday @ 3:43 PM
    Points: 2,459, Visits: 7,951
    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
    Post #1407775
    Posted Wednesday, January 16, 2013 5:35 AM
    SSChasing Mays

    SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

    Group: General Forum Members
    Last Login: Thursday, July 30, 2015 8:23 AM
    Points: 615, Visits: 1,985
    blank
    Post #1407777
    Posted Wednesday, January 16, 2013 5:36 AM
    SSChasing Mays

    SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

    Group: General Forum Members
    Last Login: Thursday, July 30, 2015 8:23 AM
    Points: 615, Visits: 1,985
    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:02 PM
    Points: 1,980, Visits: 6,690
    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


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);


  • 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
    SSChasing Mays

    SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

    Group: General Forum Members
    Last Login: Thursday, July 30, 2015 8:23 AM
    Points: 615, Visits: 1,985
    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