获取mysql 服务 名称_根据服务名称，获取sql server 里的数据库表名



一下是两种连接方式：

public List GetMSSQLDBNameList(string DSN, string UID, string PWD)

{

List databases=new List ();

SqlConnection Connection = new SqlConnection(String.Format("Data Source={0};Initial Catalog=master;User ID={1};PWD={2}", DSN, UID, PWD));

DataTable DBNameTable = new DataTable();

//从系统表master..sysdatabases中查询数据库名字            SqlDataAdapter Adapter = new SqlDataAdapter("select name from master..sysdatabases", Connection);

Adapter.Fill(DBNameTable);

foreach (DataRow Row in DBNameTable.Rows)

{

databases.Add(Row[0].ToString());

}

return databases;

}

public List GetMSSQLDBNameList(string DSN)

{

List databases = new List();

SqlConnection Connection = new SqlConnection(String.Format("Data Source={0};Initial Catalog=master;Integrated Security=True", DSN));

DataTable DBNameTable = new DataTable();

SqlDataAdapter Adapter = new SqlDataAdapter("select name from master..sysdatabases", Connection);

Adapter.Fill(DBNameTable);

foreach (DataRow Row in DBNameTable.Rows)

{

databases.Add(Row[0].ToString());

}

return databases;

}