C#枚举所有sql server数据库实例
[ 2008-03-30 16:06:58 | 作者: progame ]
这是官方解决方案 从 SqlDataSourceConverter 即可得到MS是如何去取得所有数据库服务器的
注意, 不仅仅是SERVER, 一台服务器上的多个实例(instance)都可以得到
评论Feed: /feed.asp?q=comment&id=1603
DataTable dataSources = SqlClientFactory.Instance.CreateDataSourceEnumerator().GetDataSources();
DataColumn column2 = dataSources.Columns["ServerName"];
DataColumn column = dataSources.Columns["InstanceName"];
DataRowCollection rows = dataSources.Rows;
string[] array = new string[rows.Count];
for (int i = 0; i < array.Length; i++)
{
string str2 = rows[i][column2] as string;
string str = rows[i][column] as string;
if (((str == null) || (str.Length == 0)) || ("MSSQLSERVER" == str))
{
array[i] = str2;
}
else
{
array[i] = str2 + @"\" + str;
}
}
Array.Sort<string>(array);
DataColumn column2 = dataSources.Columns["ServerName"];
DataColumn column = dataSources.Columns["InstanceName"];
DataRowCollection rows = dataSources.Rows;
string[] array = new string[rows.Count];
for (int i = 0; i < array.Length; i++)
{
string str2 = rows[i][column2] as string;
string str = rows[i][column] as string;
if (((str == null) || (str.Length == 0)) || ("MSSQLSERVER" == str))
{
array[i] = str2;
}
else
{
array[i] = str2 + @"\" + str;
}
}
Array.Sort<string>(array);
注意, 不仅仅是SERVER, 一台服务器上的多个实例(instance)都可以得到
评论Feed: /feed.asp?q=comment&id=1603
您可能感兴趣的文章:
C#和Java语言级别的几点不同 (progame at 2007-04-06)
让我们一起YAML吧 (progame at 2007-08-18)
using用用还是蛮好的 (progame at 2008-01-16)
Winform内存泄露是如此容易的一件事 (progame at 2008-08-17)
vb6升级到vb.net? 小心! (progame at 2008-10-06)
Sql Server 2000 SP4 (中英文版)下载地址 (progame at 2006-07-17)
感受ADO.Net 2.0 (progame at 2006-09-08)
安装sql server时,提示程序被挂起 (沁励 at 2007-01-08)
这篇日志没有评论.

