mysql 查询 非系统表_获取局域网所有数据库服务器、查询sqlserver非系统数据库、所有表、所有列 | 学步园...

///

///获取局域网内的所有数据库服务器名称///

/// 服务器名称数组

public ListGetSqlServerNames()

{

DataTable dataSources=SqlClientFactory.Instance.CreateDataSourceEnumerator().GetDataSources();

DataColumn column= dataSources.Columns["InstanceName"];

DataColumn column2= dataSources.Columns["ServerName"];

DataRowCollection rows=dataSources.Rows;

List Serverlist = new List();string array = string.Empty;for (int i = 0; i < rows.Count; i++)

{string str2 = rows[i][column2] as string;string str = rows[i][column] as string;if (((str == null) || (str.Length == 0)) || ("MSSQLSERVER" ==str))

{

array=str2;

}else{

array= str2 + @"\" +str;

}

Serverlist.Add(array);

}

Serverlist.Sort();r