Yes, the property sheet does provide a list of connection strings from my app.config, and when creating a new tableadapter, I can choose a connection string.

My question is how can I globally change each tableadapter to point to a specific connection string?

For example, I might want to switch from PROD to the DEV database connection string. I might have 20 tableadapters, changing each one using the property sheet is not desirable.

Isn't there a global way to do this?

Thanks,

Jerry



>the property sheet should provide a list (dropdown) of all connectionstrings, defined in your app.config file.
>You just have to choose the righ one.
>
>Normally, when you create a new tableadapter in the dataset, you have to choose a connectionstring, and the same list is provided there.