modify created connection string

19 Nov 2005 7:43 AM

Ian Burton

apologies if this issue has been dealt with previously. I have tried to
look for it, but no luck.
In visual studio, the application takes care of the connection and most of
the code, which I can go into and look at, but cannot change, because if I
make any changes to the designer, it will overwrite my changes.
I have a login form, with the ability to specify the data source and
database for sql server. I have a SqlConnectionStringBuilder object, which
i use to take the app.config application (connection string) object, and
modify it based on the selections in the form, and then, I AM STUCK.
How do I modify the connection created by the tableadapter object etc?
Thanks,
Ian

19 Nov 2005 10:17 AM

Venkat_KL

Dear Ian Burton,

read these, it may help you to some extent

Connection and Transaction properties exposed as Friend on TableAdapters
================================================
http://blogs.msdn.com/vbteam/archive/2004/07/19/187953.aspx

SqlConnectionStringBuilder.ConnectionReset Property
==================================

http://msdn2.microsoft.com/en-us/library/b2cd75k8(en-US,VS.80).aspx

SqlConnectionStringBuilder.ContextConnection Property
===================================

http://msdn2.microsoft.com/en-us/library/ms136378(en-US,VS.80).aspx

DbConnectionStringBuilder.ConnectionString Property
================================== http://msdn2.microsoft.com/en-us/library/system.data.common.dbconnectionstringbuilder.connectionstring.aspx

Connecting to Data in Visual Studio Overview
=============================

http://msdn2.microsoft.com/en-us/library/wxt2cwcc.aspx

SqlConnectionStringBuilder Properties
========================

http://msdn2.microsoft.com/en-us/library/k5w7szyc(en-us,VS.80).aspx

Bye
Venkat_KL

21 Nov 2005 6:37 PM

Ian Burton

THANKS, it worked,
I used the partial class, as mentioned, and created a connectionstring ()
property.
Then, when the dataadapter is opened by the form, I set the dataAdapter
connectionstring to be my previously made sqlbuilderconnectionstring, and it
works fine. I used sql profiler to check the different database servers,
and that works fine.
I spent about three days reading around those url subjects, and now I
understand (a little).
Thanks again.
Ian

Show quote

"Venkat_KL" <Venka***@discussions.microsoft.com> wrote in message
news:9756E1DA-CD4A-4AF3-9EB1-D57123CF9319@microsoft.com...
> Dear Ian Burton,
>
> read these, it may help you to some extent
>
> Connection and Transaction properties exposed as Friend on TableAdapters
> ================================================
> http://blogs.msdn.com/vbteam/archive/2004/07/19/187953.aspx
>
> SqlConnectionStringBuilder.ConnectionReset Property
> ==================================
>
> http://msdn2.microsoft.com/en-us/library/b2cd75k8(en-US,VS.80).aspx
>
>
> SqlConnectionStringBuilder.ContextConnection Property
> ===================================
>
> http://msdn2.microsoft.com/en-us/library/ms136378(en-US,VS.80).aspx
>
>
> DbConnectionStringBuilder.ConnectionString Property
> ==================================
> http://msdn2.microsoft.com/en-us/library/system.data.common.dbconnectionstringbuilder.connectionstring.aspx
>
> Connecting to Data in Visual Studio Overview
> =============================
>
> http://msdn2.microsoft.com/en-us/library/wxt2cwcc.aspx
>
>
> SqlConnectionStringBuilder Properties
> ========================
>
> http://msdn2.microsoft.com/en-us/library/k5w7szyc(en-us,VS.80).aspx
>
>
> Bye
> Venkat_KL