Hi all,
This is probably a very simple question. A co-worker started a project in VS2005, just doing a few page mockups, and I'm filling things in. In my Items.aspx.vb code, I have to access the database, so I thought I'd do it as I've done in ASP 1 - have a separate Modules folder with a DatabaseFunctions.vb module in it, containing the sub that actually calls the stored proc.
However, In Items.aspx.vb, it doesn't recognize the sub, even when I preface it with "DatabaseFunctions.".
I saw a mention or two of the App_Code folder, but putting DatabaseFunctions.vb there doesn't work either.
Any pointers are very appreciated... hopefully it's simple.
Thanks in advance!

What is the protection level of your method? It sounds as though you have it defined as Private.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

It wasn't that, but it was about as basic...
I moved my DatabaseFunctions.vb to the App_Code folder, where in VS2005 all code modules have to be. What I then I had to do, which I didn't realize when I wrote the question, was:
1. Replace the Module / End Module with a class name,
2. Add a namespace.
3. In my pagename.aspx.vb, imports the namespace, instantiate the class, and then I could access classname.functionname().

Thanks for taking the time to answer - I and other semi-ignernt newbies appreciate it.

Why did you create a new namespace for your class? While this is perfectly acceptable, I am not sure of the logic behind it.

For example, if you name your web project MySite, all of your code behind files and everything else becomes part of the namespace MySite. So, if i wanted to access code in pagename.aspx.vb I would do something like

Imports MySite

...code
MySite.pagename.[function or method]

So you are placing a Namespace within a namespace which is somewhat redundant for what you are doing. What you could do instead is remove the namespace from your class so all you have is your class declaration

Public Class DataBaseFunctions

End Class

You can then create an instance (assuming you have instance members in the class) of the object and access it directly without importing the namespace. So something like this

Dim df as New DatabaseFunctions()
df.[method/function]()

In any case, glad you got it working.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hi dparsons,
Just saw your post (the replies were being sent to my home email account).
You're right - I don't know why I thought a namespace was necessary. Probably it was still a Module when I added the namespace, and I left the namespace in there when I made it a class.
Embarrassing... I'm really not a moron.
Thanks again.