`
isiqi
  • 浏览: 16028421 次
  • 性别: Icon_minigender_1
  • 来自: 济南
社区版块
存档分类
最新评论

获取局域网内所有SQLServer机器名和实例名

 
阅读更多

privatevoidbutton1_Click(objectsender,EventArgse)
{
DataTabledataSources
=SqlClientFactory.Instance.CreateDataSourceEnumerator().GetDataSources();

DataColumncolumn
=dataSources.Columns["InstanceName"];
DataColumncolumn2
=dataSources.Columns["ServerName"];

DataRowCollectionrows
=dataSources.Rows;
List
<string>Serverlist=newList<string>();
stringarray=string.Empty;
for(inti=0;i<rows.Count;i++)
{
stringstr2=rows[i][column2]asstring;
stringstr=rows[i][column]asstring;
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();
}

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics