Program wont Compile

[gearbolt]

I cant get this program to compile. I have a Vb class file called dbconn.vb
which has the Database stuff in it and a function called "fallen".
When I try to access the "fallen" function from my Aspx file Visual Studio returns an error " Name fallen is not declared".
What did I miss
Thanks for the help the code is below.



dbconn.vb

Imports System.Data.SqlClient

Public Class dbconn

Private Shared ReadOnly Property ConnectionString() As String

Get
Return ConfigurationSettings.AppSettings("ConnectionString")

End Get

End Property

Public Function GetEmployeeName()
'Public Function GetEmployeeName() As SqlDataReader
' Create the connection object
Dim SqlConnection As New SqlConnection(ConnectionString)

'Create the command object
Dim command As New SqlCommand("Select * from Employess", SqlConnection)
Try
SqlConnection.Open()


Catch ex As Exception

End Try
SqlConnection.Close()



weborm1.aspx



Public Class WebForm1
Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

End Sub
Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents Button1 As System.Web.UI.WebControls.Button

'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
fallen()
End Sub

End Class

[Mike Hildner]

A couple things. One, I don't see in your dbconn class where the fallen method is defined (did you copy and paste that part?). Second, in your WebForm1, you call it as "fallen()". Assuming it was a shared method in dbconn, you'd have to call it like "dbconn.fallen()". If it's not a shared method, you need an instance reference first.

[rdove]

maybe its just me, but I do not even see the a function called fallen in the dbconn.vb code that was posted. So from what I see, that is the problem.

[gearbolt]

Forgot to copy the entire code. Here it is with the function "fallen"

Imports System.Data.SqlClient

Public Class dbconn

Private Shared ReadOnly Property ConnectionString() As String

Get
Return ConfigurationSettings.AppSettings("ConnectionString")

End Get

End Property
Public Function GetEmployeeName()
'Public Function GetEmployeeName() As SqlDataReader
' Create the connection object
Dim SqlConnection As New SqlConnection(ConnectionString)

'Create the command object
Dim command As New SqlCommand("Select * from Employess", SqlConnection)
Try
SqlConnection.Open()


Catch ex As Exception

End Try
SqlConnection.Close()

End Function

Public Function fallen()

End Function


End Class

[tailz]

You either need to declare an instance of the class "dbconn" to access "fallen" like so:


dim x as New dbconn
x.fallen


or

You need to declare "fallen" as a shared function then dbconn.fallen will work.(you can import dbconn, in which case just do "fallen" will work) - like so:


Public Shared Function Fallen()
'DO Stuff
End Function


if the function has no relevance to the class that it is in, you should either create a new class or by putting the function in a module it will make it publicly accessible...