C # lists the available SQL Server servers in the Local area network (cont.) _ Basic Application

Using System;
Using SYSTEM.DATA.SQL;
Using System.Text;

Namespace Allsqlserver
{
Class Program
{
static void Main (string[] args)
{
SQLDMO. NameList names;
SQLDMO. ApplicationClass ac = new SQLDMO. ApplicationClass ();
Names = AC. ListAvailableSQLServers ();
string[] serverlist = new String[names. Count];
for (int i = 0; i < serverlist.length; i++)
//{
Serverlist[i] = names. Item (i);
//}
foreach (String str in serverlist)
//{
Console.WriteLine (str);
//}

Sqldatasourceenumerator instance =sqldatasourceenumerator.instance;
System.Data.DataTable table = instance. Getdatasources ();

Displaydata (table);

Console.ReadLine ();
}

private static void Displaydata (System.Data.DataTable table)
{
foreach (System.Data.DataRow row in table). Rows)
{
Console.WriteLine ("Server name = {0}", row["ServerName"]);
Console.WriteLine ("Instance name = {0}", row["instancename"]);
Console.WriteLine ("Integration validation = {0}", row["isclustered"]);//Windows Authentication and SQL Server Authentication
Console.WriteLine ("Version = {0}", "row["]);//8.* is SQL 2000,9.* is SQL 2005
Console.WriteLine ("============================");
}
}
}
}

Article references from: