我有一个C#的程序需要连接Sql Server 2008 R2数据库,为了用户方便,我首先会获取域内所有Sql Server 2008 R2数据库实例,然后供用户选择合适的数据库实例。我获取数据库实例的代码如下:
/// <summary>
/// 获取网络内数据库实例
/// </summary>
/// <returns></returns>
public static string[] GetServerInstance()
{
try
{
SqlClientFactory sqlFInstance = SqlClientFactory.Instance;
DataTable dataSources = sqlFInstance.CreateDataSourceEnumerator().GetDataSources();
DataColumn column2 = dataSources.Columns["ServerName"];
DataColumn column = dataSources.Columns["InstanceName"];
//DataColumn column3 = dataSources.Columns["IsClustered"];
是否集成验证,即Windows身份验证和SQL Server验证
//DataColumn column4 = dataSources.Columns["Version"];
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;