devxlogo

Enumerating all SQL Servers

Enumerating all SQL Servers

It is quite easy to enumerate (list) all the possible SQL servers to which you want to connect. Here is a small example:

using System;using System.Data;using System.Text;using System.Windows.Forms;namespace SqlServerEnumeratorCS{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        private void GetDataSourcesButton_Click(object sender, EventArgs e)        {            System.Data.Sql.SqlDataSourceEnumerator instance =                System.Data.Sql.SqlDataSourceEnumerator.Instance;            VisibleSqlServers.DataSource = instance.GetDataSources();        }    }} 

devx-admin

Share the Post: