how do i create a public connection object in VB.net
Posted on 2006-05-04
I hav an MDI that currently has about twenty forms and is expanding as needs go on and the spec of the sofware is changed. the functionality of the forms is fine no problems but each form has its own connection object the the form uses to connect to the database to read and write. what is bothering me about this is that when the time come for ditribution of the software i am going to have to change the connection string in each and every form to get them to work. is there a way of creating a public class/sub or function that all the forms can use to connect to the database that can be changed without affecting the forms.