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
