上一篇文章展示了使用COM對(duì)象如何列出局域網(wǎng)中的 SQL Server服務(wù)器信息，后來還發(fā)現(xiàn)在.Net中有現(xiàn)成的類可用，而不需要使用不太熟悉的COM對(duì)象了，這樣豈不是更好？下面我把代碼展示給大家：
using System;
using System.Data.Sql;
using System.Text;

namespace AllSqlServer
{
    class PRogram
    {
        static void Main(string[] args)
        {
            //SQLDMO.NameList names;
            //SQLDMO.applicationClass ac = new SQLDMO.ApplicationClass();
            //names = ac.ListAvailableSQLServers();
            //string[] serverList = new string[names.Count];
            //for (int i = 0; i < serverList.Length; i++)
            //{
            //    serverList[i] = names.Item(i);
            //}
            //foreach (string str in serverList)
            //{
            //    Console.WriteLine(str);
            //}

            SqlDataSourceEnumerator instance =SqlDataSourceEnumerator.Instance;
            System.Data.DataTable table = instance.GetDataSources();

            DisplayData(table);

            Console.ReadLine();
        }

        private static void DisplayData(System.Data.DataTable table)
        {
            foreach (System.Data.DataRow row in table.Rows)
            {
                Console.WriteLine("服務(wù)器名 = {0}", row["ServerName"]);
                Console.WriteLine("實(shí)例名 = {0}", row["InstanceName"]);
                Console.WriteLine("是否集成驗(yàn)證 = {0}", row["IsClustered"]);//即Windows身份驗(yàn)證和SQL Server驗(yàn)證
                Console.WriteLine("版本 = {0}", row["Version"]);//8.*是SQL 2000,9.*是SQL 2005
                Console.WriteLine("============================");
            }
        }
    }
}