|
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.
I'm a lawyer, teacher/trainer and author of
VBA programming book (only polish version). Programming is my hobby and the source of extra earnings!
- C#
- SQL
- Linq
- VB/VBA/VB.NET
- XML & XSL
- Python
- JCL
If you want to contact me... find me on LinkedIn.