How to change the connection string of a TableAdapter

microsoft.public.dotnet.framework.adonet

22 Jun 2006 7:44 PM

I am useing the the TableAdapter of VS2005.
I copy a DataTable form one project to another project.
The connection strings in the two projects is different.
I want to change the connection of the TableAdapter to the one of the new
project. Where can I change it?

23 Jun 2006 4:47 AM

Cor Ligthert [MVP]

Ad,

In its name and than .connection, you can get it as well from there.

Dim conn As SqlClient.SqlConnection = Me.OrdersTableAdapter.Connection

I hope this helps,

Cor

Show quote

"ad" <fly***@wfes.tcc.edu.tw> schreef in bericht
news:e2tbFRjlGHA.1552@TK2MSFTNGP04.phx.gbl...
>I am useing the the TableAdapter of VS2005.
> I copy a DataTable form one project to another project.
> The connection strings in the two projects is different.
> I want to change the connection of the TableAdapter to the one of the new
> project. Where can I change it?
>

23 Jun 2006 5:11 PM

Mark

right click on the table adapter in your dataset, then properties/connection

--
Best regards
Mark

Show quote

"ad" <fly***@wfes.tcc.edu.tw> wrote in message
news:e2tbFRjlGHA.1552@TK2MSFTNGP04.phx.gbl...
>I am useing the the TableAdapter of VS2005.
> I copy a DataTable form one project to another project.
> The connection strings in the two projects is different.
> I want to change the connection of the TableAdapter to the one of the new
> project. Where can I change it?
>