Changing dataset connection string at runtime

You can modify a single instance of the table adapter.

_myAdapter.Connection.ConnectionString = connectionString;

Based on the link above, I did it this way:

partial class QueriesTableAdapter
{
    public QueriesTableAdapter(string connectionString)
    {
        Properties.Settings.Default["connectionString"] = connectionString;
    }
}