Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » SQL Server » Downloads
 
Add your own
alternative version

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-noexe.zip
SOWA_upd
SOWA_upd.suo
SOWA_upd
bin
Debug
My Project
Application.myapp
Settings.settings
obj
Debug
SOWA_upd.Form1.resources
SOWA_upd.Resources.resources
SOWA_upd.zip
SOWA_upd.suo
SOWA_upd.exe
SOWA_upd.pdb
SOWA_upd.vshost.exe
Release
Application.myapp
Settings.settings
SOWA_upd.exe
SOWA_upd.Form1.resources
SOWA_upd.pdb
SOWA_upd.Resources.resources
SOWA_upd.vbproj.GenerateResource.Cache
TempPE
My Project.Resources.Designer.vb.dll
Release
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
Follow on   LinkedIn

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