Can someone tell me what the Best Practice is for storing connection strings in .net C# WIndows form applications. I have a windows applications with several window forms that refer to EXCEL and SQL server connection strings. How do you make these global in window form applications?
strConnectionString = ExcelCon + "Data Source=" + strFileName + ";Extended Properties=" + Convert.ToChar(34).ToString() + "Excel 8.0;HDR=Yes;IMEX=1" + Convert.ToChar(34).ToString();
string cons = "Data Source=(local);Initial Catalog=MyDB;Integrated Security=SSPI;";