Sure, although if you change it when the connection is open, you need to
close and reopen the connection. A simple assignment might be what you're
after (ConnectionString = "..."). Perhaps you want to be able to do it from
outside of your cide, in whiuch case you should look into dynamic properties
or simply loading the connectionstring from you .config file.
--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Kenny" <ke***@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Hi,
Is it possible to have the connection string change during runtime? How?
Thanks,
Kenny