VB App - Connection to SQL
Posted on 2006-07-19
I have a VB.net that while in the development environment was connected up to a development database. Now that the app is being moved to the production environment the connection has to changes.
Here is my problem: All of the DataAdapters were created with the Wizard and that included the connection string. There are 100's of adapters.
How can I change these?
If this were a web app I would have a reusable piece of code that would be called and the move to Production would only take a quick change to the connnection string in that code and not have to touch all the pages....is there the ability to do that in VB.net?
If I'm going to have to touch all the pages I'd rather add something like this rather than change the dbname.
Thanks in advance.