C#列出局域网内所有的SQL SERVER服务器
在控制台中实现将局域网中所有的SQL SERVER服务器列出来,以下仅将代码贴出:
class Program
{
static void Main(string[] args)
{
foreach (string str in GetSqlServerName())
{
Console.WriteLine(str);
}
Console.ReadLine();
}
public static string[] GetSqlServerName()
{
SqlDataSourceEnumerator sqlserver = SqlDataSourceEnumerator.Instance;
DataTable db = sqlserver.GetDataSources();
string[] Name = new string[db.Rows.Count];
for (int i = 0; i < db.Rows.Count; i++)
{
Name=string.Format("IsClustered: {0:10}",db.Rows["isclustered"])
+ " " +
string.Format("\nServerName: {0:15}", db.Rows["Servername"])
+ " " +
string.Format("\nInstanceName: {0:20}", db.Rows["instancename"])
+ " " +
string.Format("\nVersion: {0:20}\n",db.Rows["version"]);
}
return Name;
}
}