Assign connection string to table adapter from session

Question

My application has already been developed, and now we are going to change the connection string that is stored in the session object (Bcoz Distributed Database Management System (DDBMS))

The problem is here .....

In that application There are so many **ObjectDataSource** which are

initialize using the .XSD file. which is associated with the TableAdapter and in which connection string the TableAdapter is assigned from the Web.Config file. How to change connection string saved in session object?

Thanks in advance.

Answer 1

XSD , ConnectionModifier Public. "", "Friend/Internal" (VB/#).

ConnectionModifier ( vs2005)! XSD ( ), .

Connection ( , ), .

Answer 2

, , LinqToSQL ( ).

, , "" , web.config , web.config . "", , - , . .

: . , . TableAdapter, , , .

Answer 3

. , . Connection , , . , , , , .

Answer 4

winforms, . , (clsGlobal), . , , clsGlobal.gstrConnectionString . , . tableadapter .

myTableAdapter.Connection.ConnectionString = clsGlobals.gstrConnectionString;

, .ToString() ta.Connection.ConnectionString.