I am working on a VS2010 Winform (not ASP web form). I have a copy of the local database on my computer. In this application, I have 3 forms in my application that need to connect to the same database, but different tables. Right now I am defining my connection string in each form something like this:
private string ConnString = "Data Source=(local);Initial Catalog=Inspections;Persist Security Info=True;User ID=MyUser;Password=MyPassword";
After I work on my project locally, I need to change it to use the real database on one of our SQL servers, so I change the string in all three forms. I have been reading on ConfigurationManager.ConnectionStrings but the way it sounds, it is for ASP/Web applications using a web.config file to store database strings? Then I read another page on adding a new item, a Settings File, under Project --> Add New Item... --> Settings File. I was able to set up both of my database strings. How do I call them or retrieve them "globally"? I tried something like:
string conn = Properties.Settings.Default.;
but stopped there because my string name is not showing up after the "Default" property.
Edited 4 Years Ago by RickL66