Hi,
I am really confused!


I have different classes in my app_code folder
in one of my classes(below) i get the records of my config table
the table contains global necessary things like adminemail and application url
now how can i make it so that it can be accessible through other classes like this:

Dim config As New myNamspace.Config
exp:label1.Text = config.websitetitle

i am confused what to use function or sub or neither
please change the code
thankss

here is my config class

Namespace MyNamespace

    Public Class Config
        Inherits System.Web.UI.Page

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


            Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrin gs("Conn").ConnectionString)
            Dim Cmd As New SqlCommand()
            Dim dr As SqlDataReader
            With Cmd
                .Connection = Conn
                .CommandType = CommandType.StoredProcedure
                .CommandText = "setting"
            End With
            Conn.Open()
            dr = Cmd.ExecuteReader()

            While dr.Read()

websiteTitle = dr("siteTitle").ToString
applicationURL = dr("appURL").ToString
adminEmail = dr("email").ToString
   End While

            dr.Close()
            Conn.Close()
        End Sub

  End Class

End Namespace

Normally to access values on a class you use properties. For example:

    Public Property WebSiteTitle() As String
        Get
            Return _webSiteTitle
        End Get
        Set(ByVal value As String)
            _webSiteTitle = value
        End Set
    End Property

(_webSiteTitle is the internal variable in the class that contains the value you wish to get.)

Alternatively you could use a method to return the value.


Are you intending to use this Config class as a utility class? If so, you shouldn't derive it from System.Web.UI.Page because this class will never be instantiated as a web page. Thus the Page_Load method you have in it will never run. Instead, put all of that code into a class constructor so it gets run when you create the instance of it.

-Peter

thanks
i did exactly what you say but i get this error:
Argument not specified for parameter 'WebsiteTitle' of 'Public Sub New(WebsiteTitle As String)'.
I have no idea how to use a function or sub

under Dim config As New myname.Config
config name i get that error
  Private _websiteTitle As String

        Public Sub New(ByVal WebsiteTitle As String)
            MyBase.New()
            _websiteTitle = WebsiteTitle

        End Sub

        Public Property WebsiteTitle() As String
            Get
                Return _websiteTitle
            End Get
            Set(ByVal Value As String)
                _websiteTitle = Value
            End Set
        End Property

 Public sub GetConfig()

Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrin gs("Conn").ConnectionString)
            Dim Cmd As New SqlCommand()
            Dim dr As SqlDataReader
            With Cmd
                .Connection = Conn
                .CommandType = CommandType.StoredProcedure
                .CommandText = "cmmSP_setting"
            End With
            Conn.Open()
            dr = Cmd.ExecuteReader()

            While dr.Read()

               WebsiteTitle = dr("siteTitle").ToString

            End While

dr.Close()
            Conn.Close()
end sub

You constructor is expecting a value for web site title. However, the whole point of this class is to get it from the database. Remove the argument from the constructor and move all the code you have in the Config() method into the constructor as I previously suggested. Then the database call will be made when you create the instance of this class without requiring a call to another method to load the data.

-Peter

Thanks a lot planie it worked