modify created connection string

  • Thread starter Thread starter Ian Burton
  • Start date Start date
I

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
 
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/li...connectionstringbuilder.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
 
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
 
Back
Top