[dba-VB] How to set password for a DataTable(Adapter)'s connection?

Hi all

Is it possible at runtime to set the password for the connection when you open a DataTableAdapter?

I have code like this:

            // DataTableAdapter to copy from.
            RemoteTableAdapters.CompanyTableAdapter sourceDataTableAdapter =
                new RemoteTableAdapters.CompanyTableAdapter();
            Remote.CompanyDataTable sourceDataTable;

            // DataTableAdapter to copy to.
            LocalTableAdapters.CompanyTableAdapter targetDataTableAdapter =
                new LocalTableAdapters.CompanyTableAdapter();
            Local.CompanyDataTable targetDataTable;

            // DataTable for source.
            sourceDataTable = sourceDataTableAdapter.GetData();
            // DataTable for target.
            targetDataTable = targetDataTableAdapter.GetData();

If the underlying database connection needs a password, the code fails at the line with GetData().

Would I need to go all the way back to read the ConnectionString, modify this, and reapply? How?
Or is there a more clever method? At best like:

          targetDataTableAdapter.Connection.SetPassword("secret");

/gustav