110,561
社区成员
发帖
与我相关
我的任务
分享
SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
System.Data.DataTable table = instance.GetDataSources();
List<string> serverList = new List<string>();
DataTable dataTable = SqlDataSourceEnumerator.Instance.GetDataSources();
DataRow[] rows = dataTable.Select("", "ServerName,InstanceName Asc");
foreach (DataRow row in rows)
{
string server = row["ServerName"].ToString();
if (string.IsNullOrEmpty(row["InstanceName"].ToString()) == false)
{
server = server + "\\" + row["InstanceName"].ToString();
}
serverList.Add(server);
}