不用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
posted @ 2008-07-06 18:10  世之云枭  阅读(401)  评论(1)    收藏  举报