<div>
<div class="content wysiwyg-content">
I have a scenario that appears from my research to be a common issue but have yet to find a solution. &nbsp;The scenario is:<br />
<br />
1. I have a VS2010 VB.NET Application<br />
2. Within this project I have added a datasource and this has created an xsd designer object<br />
3. The ConnectionString created is a Application Scope setting (this is I understand not optional and cannot be a user scoped setting)<br />
4. The ConnectionString setting refers to a database on my development server<br />
<br />
This application is not an 'internal' company application but one that will be distributed to many clients, each of which have their own networks, servers etc.<br />
<br />
The problem comes in that the ConnectionSetting is read only so how, when I deploy the application, and it is installed on a client network can the client select the database to connect to.<br />
<br />
This does seem to be a fundamental requirement of distributing applications but I cannot find anywwhere a solution other than to not use the datasource objects and use my own code to connect to data sources and have unbound controls.<br />
<br />
Is there a solution to this problem or alternative strategies/methods for connecting to a datasource and using strongly typed datasets with bound controls?<br />

</div>
</div>


I have a scenario that appears from my research to be a common issue but have yet to find a solution.  The scenario is:

1. I have a VS2010 VB.NET Application
2. Within this project I have added a datasource and this has created an xsd designer object
3. The ConnectionString created is a Application Scope setting (this is I understand not optional and cannot be a user scoped setting)
4. The ConnectionString setting refers to a database on my development server

This application is not an 'internal' company application but one that will be distributed to many clients, each of which have their own networks, servers etc.

The problem comes in that the ConnectionSetting is read only so how, when I deploy the application, and it is installed on a client network can the client select the database to connect to.

This does seem to be a fundamental requirement of distributing applications but I cannot find anywwhere a solution other than to not use the datasource objects and use my own code to connect to data sources and have unbound controls.

Is there a solution to this problem or alternative strategies/methods for connecting to a datasource and using strongly typed datasets with bound controls?


VB.NET 2010 ADO Connection String

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.