用c#如何查看本机下的所有SQL SERVER2008实例,谢谢

RegistryKey key = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL");

            string[] str_server = key.GetValueNames();

            string str_hostname = Dns.GetHostName();//取得主机名

            for (int i = 0; i < str_server.Length; i++)

            {

                //str_server[i] = str_hostname + "\\" + str_server[i];//在SQL 实例中加上主机名

                Console.WriteLine(str_server[i]);

            }

C#枚举所有sql server数据库实例



C# code

DataTable dataSources = SqlClientFactory.Instance.CreateDataSourceEnumerator().GetDataSources();

 DataColumn column2 = dataSources.Columns["ServerName"];

 DataColumn column = dataSources.Columns["InstanceName"];

 DataRowCollection rows = dataSources.Rows;

 string[] array = new string[rows.Count];

 for (int i = 0; i < array.Length; i++)

 {

 string str2 = rows[i][column2] as string;

 string str = rows[i][column] as string;

 if (((str == null) || (str.Length == 0)) || ("MSSQLSERVER" == str))

 {

 array[i] = str2;

 }

 else

 {

 array[i] = str2 + @"\" + str;

 }

 }

 Array.Sort<string>(array);





以上是官方的做法，从 SqlDataSourceConverter 即可得到MS是如何去取得所有数据库服务器的