Click here to Skip to main content
12,629,684 members (32,980 online)
Click here to Skip to main content
Articles » Database » Database » SQL Server » Downloads

Stats

27.3K views
1.7K downloads
10 bookmarked
Posted

How to enum SQL Server instances in network

, 13 Feb 2013 CPOL
This tip is desired for those who want to list all available SQl Server instances that are in a network.
SOWA_upd
SOWA_upd.suo
SOWA_upd
bin
Debug
My Project
Application.myapp
obj
Debug
SOWA_upd.Form1.resources
SOWA_upd.Resources.resources
SOWA_upd.suo
SOWA_upd.exe
SOWA_upd.vshost.exe
Application.myapp
SOWA_upd.exe
SOWA_upd.Form1.resources
SOWA_upd.Resources.resources
TempPE
My Project.Resources.Designer.vb.dll
Public Class Form1

    Public Sub New()

        ' This call is required by the Windows Form Designer.
        InitializeComponent()

        ' Add any initialization after the InitializeComponent() call.
        Dim dt As Data.DataTable = Nothing, dr As Data.DataRow = Nothing

        Try
            dt = Sql.SqlDataSourceEnumerator.Instance.GetDataSources()


            For Each dr In dt.Rows
                Me.CmbSQLInstance.Items.Add(dr.Item(0).ToString)
            Next
            Me.DGVSQLInstances.DataSource = dt

        Catch ex As System.Data.SqlClient.SqlException
            MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error!")

        Catch ex As Exception
            MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error!")

        Finally
            dr = Nothing
            dt = Nothing
        End Try


    End Sub

    Protected Overrides Sub Finalize()
        MyBase.Finalize()
    End Sub
End Class

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Maciej Los
Team Leader
Poland Poland
I'm a lawyer, teacher/trainer and author of VBA programming book (only polish version). Programming is my hobby!
  1. VB/VBA/VB.NET
  2. C#
  3. C++
  4. SQL
  5. Linq
  6. XML & XSL

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.161205.3 | Last Updated 13 Feb 2013
Article Copyright 2013 by Maciej Los
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid