Posted on: 6/4/2015 5:19:58 PM | Views : 783

I am using a SQL Server 2008 R2 Express database (.mdf) with a Visual Studio 2010 C# WinForms application. My DB's connection string currently points to the folder where my TEST application resides, i.e., SqlConnection conn = new System.Data.SqlClient.SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Visual C# 2010 Projects\\Windows Controls Test\\WinForm_Controls-Test\\WinForm_Controls-Test\\ControlTest.mdf;Integrated Security=True;User Instance=True"); My questions are as follows: Although this obviously is a test application, when I deploy my C# applications using ClickOnce deployment, where does the connectionString point to, since the App no longer resides in a projects folder on my C: drive? Will my connection continue to work with the distributed SQL database? I also noticed in a app.config file that there is a connectionString that drops the aforementioned director ...

Go to the complete details ...