How to change the connection string of a TableAdapter

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?

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


"ad" <flying@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?
>

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

--
Best regards
Mark

"ad" <flying@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?
>