Changing the connection string for a Typed Data Set

Question

I created a typed data set in one project, and moved it to another. The orginal connectionstring it created in the settings file was something like "myconnectionstring2". When I moved it to the new project I went into the project settings file and created a connection string called "myconnectionstring". I'm trying to get the typed dataset to use my new connection string but the generated code is still looking for "myconnectionstring2" . Where do I change the setting? I can't seem to find it in the typed dataset properties.

Answer 1

I found it. You have to click the "xxxTableAdapter" in the designer to get access to the connection string setting. You can specify a different connection string for each table adapter in your dataset. My problem was that I was looking for a DataSet/Top Level connection string property.