AppSettings.ConnectionString["string name"].'property' should be settable IIRC.
∞ Andy Badera ∞ +1 518-641-1280 ∞ This email is: [ ] bloggable [x] ask first [ ] private ∞ Google me: http://www.google.com/search?q=andrew%20badera On Mon, Sep 28, 2009 at 3:09 PM, digger_54 <[email protected]> wrote: > > Hi, > > Need some help in VS2005 vb.net. I need to change my connection string > to a different server depending on the location of a user, I have to > code to get the users location. > > connectionString="Data Source= location1;Persist Security > Info=True;Integrated Security=False;User > ID=Username;Password=PW;Unicode=True" > > How can I change the ="Data Source= location1 part of it if the person > belongs to location2? > > Thanks >
