private void button1_Click(object sender, EventArgs e)
{
DataTable dataSources = SqlClientFactory.Instance.CreateDataSourceEnumerator().GetDataSources();
DataColumn column = dataSources.Columns["InstanceName"];
DataColumn column2 = dataSources.Columns["ServerName"];
DataRowCollection rows = dataSources.Rows;
List<string> Serverlist = new List<string>();
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;
Console.WriteLine(array);
}
else
{
array = str2 + @"\" + str;
Console.WriteLine(array);
}
Serverlist.Add(array);
}
Serverlist.Sort();
}
posted on 2011-03-17 14:19
Ying-er 閱讀(572)
評論(0) 編輯 收藏 所屬分類:
.Net