22,209
社区成员
发帖
与我相关
我的任务
分享
Dim Enumerator As Sql.SqlDataSourceEnumerator = Sql.SqlDataSourceEnumerator.Instance
Dim dt As Data.DataTable
dt = Enumerator.GetDataSources()
Dim servername, instance As String
For Each row As DataRow In dt.Rows
For Each col As DataColumn In dt.Columns
Console.WriteLine("{0} = {1}", col.ColumnName, row(col))
If col.ColumnName = "ServerName" Then
servername = row(col)
End If
If col.ColumnName = "InstanceName" Then
instance = servername + "\" + row(col)
ComboBox1.Items.Add(instance)
End If
Next
Next