Csharp/CSharp Tutorial/ADO.Net/SqlDataSourceEnumerator
Obtain the DataTable of SQL Server instances and display the list of the SQL Servers
<source lang="csharp">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"]); } } }
}</source>