Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: .NET
Expertise: Beginner
Apr 14, 2017

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();
        }
    }
} 
Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date