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

Hi Gustav:

That is a helpful piece of information.

Jim

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, February 21, 2008 4:34 AM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] How to set password for a DataTable(Adapter)'s
connection?

Hi all

OK, I found out. The DataTableAdapter has a Connection which has a
ConnectionString property, and you can modify that using the
SqlConnectionStringBuilder.

Here is for my targetDataTableAdapter:

  Console.WriteLine(targetDataTableAdapter.Connection.ConnectionString);

  // Define password.
  string password = (string)"YourSecretPassword";
  // Retrieve connection string.
  SqlConnectionStringBuilder sqlConnectionStringBuilder = new
SqlConnectionStringBuilder(); 
  sqlConnectionStringBuilder.ConnectionString =
targetDataTableAdapter.Connection.ConnectionString;
  // Apply password to connection string.
  sqlConnectionStringBuilder.Password = password;
  // Apply the modifed connection.
  targetDataTableAdapter.Connection = new
SqlConnection(sqlConnectionStringBuilder.ToString());

  Console.WriteLine(targetDataTableAdapter.Connection.ConnectionString);

/gustav

>>> Gustav at cactus.dk 20-02-2008 20:38 >>>
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


_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com