Hi,
I've created a class that contains a common function. When I try to invoke
the function or method, I get the error:
BC30451: Name 'dataClass' is not declared.
The class file dataClass.vb contains the following:
Imports System
Namespace MySpace
Public Class dataClass
Public Shared Function GetPage(ByVal pageNumber As Integer, ByVal
lessonNumber As Integer, ByVal courseNumber As Integer) As
System.Data.IDa taReader
Dim strConnection As String
strConnection = ConfigurationSe ttings.AppSetti ngs
("ConnectionStr ing")
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Sql Client.SqlConne ction(strConnec tion)
Dim queryString As String = "SELECT [tblPage].*, [tblLesson].
[LessonNumber], [tblCourse].[CourseNumber] FROM [tblPage], [tblLesson],
[tblCourse] WHERE (([tblPage].[Pa"& _
"geNumber] = @PageNumber) AND ([tblLesson].[LessonNumber] =
@LessonNumber) AND (["& _
"tblCourse].[CourseNumber] = @CourseNumber)) AND
tblPage.lessonI D = tblLesson.lesso nID AND tblLesson.Cours eID =
tblCourse.Cours eID"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Sql Client.SqlComma nd
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dbParam_pageNum ber As System.Data.IDa taParameter = New
System.Data.Sql Client.SqlParam eter
dbParam_pageNum ber.ParameterNa me = "@PageNumbe r"
dbParam_pageNum ber.Value = pageNumber
dbParam_pageNum ber.DbType = System.Data.DbT ype.Int32
dbCommand.Param eters.Add(dbPar am_pageNumber)
Dim dbParam_lessonN umber As System.Data.IDa taParameter = New
System.Data.Sql Client.SqlParam eter
dbParam_lessonN umber.Parameter Name = "@LessonNum ber"
dbParam_lessonN umber.Value = lessonNumber
dbParam_lessonN umber.DbType = System.Data.DbT ype.Int32
dbCommand.Param eters.Add(dbPar am_lessonNumber )
Dim dbParam_courseN umber As System.Data.IDa taParameter = New
System.Data.Sql Client.SqlParam eter
dbParam_courseN umber.Parameter Name = "@CourseNum ber"
dbParam_courseN umber.Value = courseNumber
dbParam_courseN umber.DbType = System.Data.DbT ype.Int32
dbCommand.Param eters.Add(dbPar am_courseNumber )
dbConnection.Op en
Dim dataReader As System.Data.IDa taReader =
dbCommand.Execu teReader(System .Data.CommandBe havior.CloseCon nection)
Return dataReader
End Function
End Class
End Namespace
When trying to invoke it, I use:
<ASP:Repeater id="RepeaterPag eText" runat="server" DataSource="<%#
dataClass.GetPa ge(1,1,1) %>">
<ItemTemplate >
<%# DataBinder.Eval (Container.Data Item, "pageText") %>
</ItemTemplate>
</ASP:Repeater>
Am I supposed to declare the class in the page I'm going to use? The class
file exists in the root of the application.
Thanks
--
Message posted via http://www.dotnetmonster.com