Changing the Connection of a Query in a TypedDataSet at Runtime

I have a TypedDataSet. Within it there is a QueriesTableAdapter with a bunch
of Queries(stored procedures that perform updates & deletes). I need to
change the Connection of the Query at runtime. Of course, I can't change the
ConnectionString in My.Settings at runtime because it's ReadOnly.
Unfortunately, I can't find where the Query exposes a
Connection/ConnectionString property that I can change!

This seems a bit odd since I can change the Connections of TableAdapters at
runtime.


--
Michael