StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Enumerate Database Names

Enumerate Database Names

Kent Meyer — Tue, 27 Feb 2007 17:10:06 GMT

How do I get a list of Databases available on a Server?

RE: Enumerate Database Names

StrataFrame Team — Tue, 27 Feb 2007 17:10:06 GMT

Ah, the ConnectionManager uses the GetSchema() method internally, but I don't believe that the method is exposed to enumerate the databases. We have a background worker thread that gathers the available databases when the you click the drop-down for the database selection.

RE: Enumerate Database Names

Kent Meyer — Tue, 27 Feb 2007 14:37:54 GMT

I was just wondering if there was a way do do this using the Strataframe connection manager...

RE: Enumerate Database Names

StrataFrame Team — Mon, 26 Feb 2007 09:23:38 GMT

Yes, the GetSchema() is probably the preferred way to do it. You can also look at the sys.sysobjects view and I think there is a sys.sysdatabases view, but using GetSchema() is version independent. Also, if you call GetSchema() and don't pass it any restrictions, it will give you a DataTable containing the different schema objects that can be queried and the restrictions that are needed to narrow each of the selections.

RE: Enumerate Database Names

Kent Meyer — Sun, 25 Feb 2007 12:00:17 GMT

Here is one way....

SqlConnectionStringBuilder cnStr = new SqlConnectionStringBuilder();

cnStr.UserID = this.txtUsername.Text;

cnStr.Password = this.txtPassword.Text;

cnStr.DataSource = this.cboSQLServer.Text;

cnStr.ConnectTimeout = 30;

SqlConnection cn = new SqlConnection();

cn.ConnectionString = cnStr.ConnectionString;

cn.Open();

System.Data.DataTable dbList = cn.GetSchema("Databases");

foreach (System.Data.DataRow row in dbList.Rows)

{

this.cboDatabase.Items.Add(row[0]);

}