Im starting a new project (first in .NET) and Im thinking that this is the time to change the things that im not doing very well.
The question is, I have a project with 7-10 forms, all have access (and use) the same SQL or Access database.
How would be the best way to handle connections?
one option is to open/close connections in every form, other is to make connection public in one form...
what other ways are there? and...what would be the best approach?
Thanks!