How do I change the SQL ConnectionString when I am developing this appliaction in my Office and yet be able to deploy it at my customers location?
Below is the current code that was suppose to allow me to automatically switch between installed locations, but it is NOT. Is there something that I did or did not do when publishing the application or during the installation of the appliaction?
Private Function GetData() As DataTable
Dim connectionString As String = String.Empty
#If Debug = True Then
connectionString = My.Settings.PLMConnectionStringDev 'Development connection string
connectionString = My.Settings.PLMConnectionStringDeploy 'Deployment connection string
Dim SQL As String = "SELECT * FROM myTable"
Dim table As New DataTable()
Dim adapter As New SqlClient.SqlDataAdapter(SQL, connectionString)