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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 9:18 AM
Points: 451, Visits: 1,424
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 1,300, Visits: 3,891
And do you actually have a component on the page called GridView1?

MM




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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:16 AM
Points: 2,236, Visits: 6,486
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 9:18 AM
Points: 451, Visits: 1,424
blank
Post #1407777
Posted Wednesday, January 16, 2013 5:36 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 9:18 AM
Points: 451, Visits: 1,424
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 1,300, Visits: 3,891
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




Post #1407783
Posted Wednesday, January 16, 2013 7:59 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 9:18 AM
Points: 451, Visits: 1,424
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