I am using VS2005. I have created a strongly type dataset(XSD) with many different table adapters. When defining my table adapters, I set the Connection property to either my production or development SQL Server database. I do this through the property sheet at design time.

How can I set the connection string using the connection string property that is in the app.config file?

Currently, in order to switch from the DEV to PROD SQL Server databases, I have to change the Connection property for each table adapter. Is there a way to make every table adapter read it's connection string from the config file?

Thanks,

Jerry