VB.Net/Database ADO.net/DataTable — различия между версиями
Admin (обсуждение | вклад) м (1 версия)  | 
				|
(нет различий) 
 | |
Версия 16:40, 26 мая 2010
Obtain the DataTable of SQL Server instances
  
Imports System
Imports System.Data
Imports System.Data.Sql
    Public Class MainClass
        Public Shared Sub Main()
            Using sqlSources As DataTable = SqlDataSourceEnumerator.Instance.GetDataSources()
                For Each source As DataRow In sqlSources.Rows
                    Console.WriteLine(" Server Name:{0}", source("ServerName"))
                    Console.WriteLine(" Instance Name:{0}", source("InstanceName"))
                    Console.WriteLine(" Is Clustered:{0}", source("IsClustered"))
                    Console.WriteLine(" Version:{0}", source("Version"))
                    Console.WriteLine(Environment.NewLine)
                Next
            End Using
        End Sub
    End Class