C# 获取SQL Server所有的数据库名称

参考文章：http://www.cnblogs.com/Abel_cn/archive/2008/12/09/1351425.html

http://blog.csdn.net/friendan/article/details/52182923

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

[csharp] view plain copy

1. 1. // ...  
   2.   
   3.   
   4.   
   5.   
   6.   
   7.                 /// <summary>  
   8.         /// 获取数据库连接对象  
   9.         /// </summary>  
   10.         /// <param name="dbName"></param>  
   11.         /// <returns></returns>  
   12.         public SqlConnection getSqlConnection(string dbName)  
   13.         {  
   14.             SqlConnection conn = new SqlConnection();  
   15.             conn.ConnectionString = string.Format("server=127.0.0.1,9527;database={0};uid=sa;pwd=123456;Enlist=true", dbName);  
   16.             conn.Open();  
   17.             //showLog(string.Format("连接数据库成功：{0}", conn.Database));  
   18.             return conn;  
   19.         }  
   20.           
   21.           
   22.          /// <summary>  
   23.          /// 取所有数据库名称  
   24.          /// </summary>  
   25.          /// <returns></returns>  
   26.          public ArrayList  getAllDbName()  
   27.          {  
   28.              ArrayList dbNameList = new ArrayList();  
   29.              DataTable dbNameTable = new DataTable();  
   30.              SqlConnection conn = getSqlConnection("master");  
   31.              SqlDataAdapter adapter = new SqlDataAdapter("select name from master..sysdatabases",  conn);  
   32.              lock (adapter)  
   33.              {  
   34.                  adapter.Fill(dbNameTable);  
   35.              }  
   36.              foreach (DataRow row in dbNameTable.Rows)  
   37.              {  
   38.                  dbNameList.Add(row["name"]);  
   39.              }  
   40.              conn.Close();   
   41.              return dbNameList;  
   42.          }  
   43.           

转载于:https://www.cnblogs.com/LuoEast/p/8493172.html