VB.Net/Database ADO.net/DataTable — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Версия 19:40, 26 мая 2010
Obtain the DataTable of SQL Server instances
<source lang="vbnet"> 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 </source>