title: How to set a table adapter's connection string (to one that is dynamically set)
body: <p>I just inherited the role of "Database Guy" from another developer who is no longer with the company, so please forgive me if I sound particularly noobish.</p>
  
  <p>The application is a VB.NET 4 application.</p>
  
  <p>The DB connection string for our table adapters was a string in my.settings (My.Settings.DBConnectionString) that is being set at runtime.  When I had to modify the table adapters they couldn't see any data in My.Settings.DBConnectionString and thus did not allow me to edit them until I set a "real" (or hard-coded) connection string.  Now I want to change it back to the dynamically set one, but Visual Studio doesn't seem to want to let me do that.  I believe I've found the spot in the auto-generated code behind the .xsd file to be able to change the connection string for a particular table adapter, but if I do that will bad things happen?  Or is there some other mechanism for changing a table adapter's connection string other than the properties pane on the side of Visual Studio that I am not aware of?</p>
  
  <p>Just as a secondary question, are there bad / not-best practices going on here?</p>
  
  <p>Thanks!</p>