Where should I store functions and subs to be called throughout my application?

Question

1.00/5 (1 vote)

See more:

I have been told to keep common subs and functions inside a module and call them from there, is this right?

What I have tried:

I have tried a module and it works fine but wondered if it was the right way.

Posted 20-Jun-17 11:12am

BeginnerCoderPete

Updated 20-Jun-17 19:04pm

Add a Solution

Comments

PIEBALDconsult 20-Jun-17 23:28pm

Yes.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2017-06-20T19:04:00

Solution 1

Yes, it's the right way: the alternative is to use a class full of Shared methods, and that gets messy, because a class should be designed for inheritance and instantiation - which isn't possible with a Shared method. Modules are the VB counterpart of C# static classes, and are the only way you can do some things, such as extension methods for example.
Using a module lets you declare methods that are available anywhere the module is without needing to preface the method name with the class.

Posted 20-Jun-17 19:04pm

OriginalGriff

Comments

BeginnerCoderPete 21-Jun-17 8:06am

Excellent, Thank you!

OriginalGriff 21-Jun-17 8:16am

You're welcome!

BeginnerCoderPete 21-Jun-17 16:49pm

Is it possible to pass a TableAdaptor from my Form to the Module?

OriginalGriff 22-Jun-17 0:24am

Yes. You can pass anything to anywhere by passing it as a parameter.

BeginnerCoderPete 22-Jun-17 4:11am

The problem is though that Table Adaptors don't have a base class so I can't do what I'd normally do and say (ta as TableAdaptor) so I was trying to find another way. I thought maybe pass the name through as a string then somehow find the table adaptor with an name that matches. I ran into difficulties there too.