<div>
Remove the conOne from the project, save the project, rebuild it, and try again. You should see where the conOne was used and then you may replace it by conTwo.
</div>


Remove the conOne from the project, save the project, rebuild it, and try again. You should see where the conOne was used and then you may replace it by conTwo.

<div>
Yes I did that, it works for a small time.<br />
<br />
I have another project with the same problem. No I set all the tableadapter connection strings on each page. It's a solution, but not a good solution.
</div>


Yes I did that, it works for a small time.

I have another project with the same problem. No I set all the tableadapter connection strings on each page. It's a solution, but not a good solution.

<div>
<div class="content wysiwyg-content">
I have the following problem:<br />
<br />
I have a Visual Studio (VB) 2013 project with a datasource. This datasource contains one table.<br />
The project contains two connection strings(conOne and conTwo). I changed the connectionstring (manually in the properties) of the tableadapter to conTwo. <br />
<br />
When I start the program the connectionstring it use always conOne. <br />
In this code, it prints always conOne.<br />
&nbsp;
<pre><code id="code-10-28515252-1">Dim tba As New dsTableAdapters.tbaTest
        MsgBox(tba.Connection.Database)
        MsgBox(tba.Connection.ToString)</code></pre>
<br />
In the properties of the tableadapter it is connection Two.<br />
<br />
Please help me. It is very important for us. We use also VS 2008 at this moment and we don't have this problem in 2008.<br />
Anyone know a solution for this problem?
</div>
</div>


I have the following problem:

I have a Visual Studio (VB) 2013 project with a datasource. This datasource contains one table.
The project contains two connection strings(conOne and conTwo). I changed the connectionstring (manually in the properties) of the tableadapter to conTwo. 

When I start the program the connectionstring it use always conOne. 
In this code, it prints always conOne.
 (CODE)

In the properties of the tableadapter it is connection Two.

Please help me. It is very important for us. We use also VS 2008 at this moment and we don't have this problem in 2008.
Anyone know a solution for this problem?

[VB 2013] Tableadapter Connectionstring

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.