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.

Tim Sweet

All creation of object in .NET results in text-based components (which are closed up within Region tags). That's point 1.
Point 2 is that all .NET end components (.DLLs, .EXEs, .ASPXs) have XML based configuration files associated with them, itno which you can put custom properties which are accessed automatically.

Combining 1 & 2, you should be able to set up custom properties identifiying the database connection particulars, which properrties would then be automatically loaded. In the strings that establish the connections of the DataAdapters, substitute references to these custom properties. (You can probably do the lion's share of this work with a global search-and-replace.)