不用SQLDMO也能获取服务器里所有数据库列表
#region 获取服务器里所有数据库列表
public DataTable GetMSSQLDBNameList(string DSN, string UID, string PWD)
{
ArrayList DBNameList = new ArrayList();
SqlConnection Connection = new SqlConnection(String.Format("Data Source={0};Initial Catalog=master;User ID={1};PWD={2}", DSN, UID, PWD));
DataTable DBNameTable = new DataTable();
SqlDataAdapter Adapter = new SqlDataAdapter("select name from master..sysdatabases", Connection);
Adapter.Fill(DBNameTable);
return DBNameTable;
}
#endregion
public DataTable GetMSSQLDBNameList(string DSN, string UID, string PWD)
{
ArrayList DBNameList = new ArrayList();
SqlConnection Connection = new SqlConnection(String.Format("Data Source={0};Initial Catalog=master;User ID={1};PWD={2}", DSN, UID, PWD));
DataTable DBNameTable = new DataTable();
SqlDataAdapter Adapter = new SqlDataAdapter("select name from master..sysdatabases", Connection);
Adapter.Fill(DBNameTable);
return DBNameTable;
}
#endregion
浙公网安备 33010602011771号