Thread: Class library

cool will check out that link.

as per my previous question:
ok so i won't reuse the code in other projects, lets say this app / website
will only use these classes.

where do i store these classes, and how do i 'include / reference' them in my diff pages?

Shem

Just a an example of what I think you're after, this is what I use at the moment (admittedly after reading J's link in the past, layered apps sound the way to go), but this is what I do.

Create a seperate .vb file for your "re-useable" code. For instance, I have one for user_details.
user_details.vb. This file goes in your App_Code folder.

Code:

Imports Microsoft.VisualBasic
Imports MySql.Data.MySqlClient 'only needed because I use MySQL
 
Public Class user_details
 
  Private Shared _userref as Integer
 
  Public Shared Property userref as integer
    get
         return _userref
    end get
 
    set(ByVal value as Integer)
         _userref = value
    end set
  End Property
 
  Public shared function forename() as string
    Dim conn as new mysqlconnection("your_connection_string")
    Dim mycommand as new mysqlcommand
    mycommand.connection = conn
    Dim rs as new mysqldatareader
         Try
               mycommand.commandtext = "SELECT forename FROM users WHERE userref=?userref"
               mycommand.parameters.addwithvalue("userref",userref)
               conn.open()
               rs = mycommand.executereader()
               if rs.hasrows then
                    rs.read()
                    return rs("forename")
               else
                    return ""
               end if
               rs.close
          catch ex as exception
               return ex.message.tostring
          finally
               mycommand.dispose()
               conn.close
               conn.dispose
           end try
  End Function
 
End Class

Then in your code behind:-

Code:

Sub Page_Load
      if not ispostback then
                user_details.userref = 1 'or whatever value you want
 
                lbl_userforename.text = user_details.forename
      end if
end sub

Hope that helps Shem

cool thanks alot guys.
both your explanations will help me achieve my goals

@RR: thats exactly what i was after, that is what or how i want to code in .net
but will still have to go JMH's way in the end

Shem

@ RR:
is this how you are coding in .net at the moment?

Originally Posted by jmurrayhead

Indeed...JMH's way is much cleaner Separating all your business objects, business logic and data access layers is a great way to organize and reuse code. Keep in mind, that example I provided is very basic and once you get used to it you will be able to expand on it. Don't limit yourself to stick strictly to that example

I'll keep that in mind, thanks

Originally Posted by Shem

@ RR:
is this how you are coding in .net at the moment?

Yep...I'm still a noob and need to push this project on, so figure I'll get things working pretty well then look at making improvements at a later date...

I believe using layers you basically call the business logic layer in your top level code and this in turn makes a call to the data access layer to gather the data.

Correct me if I'm wrong J!!