Information générale
Catégorie:
Bases de données
Titre:
How to set connection string using config file
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement