Obtain the DataTable of SQL Server instances and display the list of the SQL Servers : SqlDataSourceEnumerator : ADO.Net C# Examples

    
using  System;
using  System.Data;
using  System.Data.Sql;

class  MainClass
{
        public  static  void  Main(string[]  args)
        {
                using  (DataTable  SqlSources  =  SqlDataSourceEnumerator.Instance.GetDataSources())  {
                        foreach  (DataRow  source  in  SqlSources.Rows)
                        {
                                Console.WriteLine("  Server  Name:{0}",  source["ServerName"]);
                                Console.WriteLine("  Instance  Name:{0}",  source["InstanceName"]);
                                Console.WriteLine("  Is  Clustered:{0}",  source["IsClustered"]);
                                Console.WriteLine("  Version:{0}",  source["Version"]);
                        }
                }
        }
}