how to change the connection string

's Computer Specifications

Hi,
I have a dataset with few tableAdapter and I wish to change the
connection string by user imput, the only way I found to do that is
using each tableadapter, but in this way I have change one by one.
Any one know a faster way ?
Thanks,
PaoloL.

's Computer Specifications

PaoloL,

Unfortunately, that is the only way to do it. The table adapters have a
connection that is set when you create them.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- (E-Mail Removed)

"paolol" <paolol@no_spamsalsan.net> wrote in message
news:(E-Mail Removed)...
> Hi,
> I have a dataset with few tableAdapter and I wish to change the connection
> string by user imput, the only way I found to do that is using each
> tableadapter, but in this way I have change one by one.
> Any one know a faster way ?
> Thanks,
> PaoloL.

's Computer Specifications

Thanks a lot Nicholas.

Paolol

Nicholas Paldino [.NET/C# MVP] ha scritto:
> PaoloL,
>
> Unfortunately, that is the only way to do it. The table adapters have a
> connection that is set when you create them.
>
> Hope this helps.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Connection String from SQL to Access	Michelle	Microsoft Access	3	1st Feb 2007 07:26 PM
Change Connection String during runtime	Sankalp	Microsoft VB .NET	1	28th Dec 2006 05:58 PM
change connection string dynamically	sam44	Microsoft ASP .NET	37	29th Jul 2006 09:24 PM
Change connection string	=?Utf-8?B?c21rMjM=?=	Microsoft Access VBA Modules	3	26th May 2005 12:09 AM
How to dynamically change the connection string	John	Microsoft Access External Data	0	13th Jul 2004 05:50 AM