C # lists the available SQL Server servers in the local area network _mysql

SQLDMO is provided by Microsoft SQL Server's SQLDMO.dll, and since SQLDMO.dll is a COM object, you must add a reference to it in the. NET project before you use it. Note To add a COM reference, locate the Microsoft SQLDMO Object Library in the list (possible path: System letter: \program Files\Microsoft SQL Server\80\tools\binn\ Sqldmo.dll), and then click OK to add the reference.
The following is a class written in the C # language to enumerate the Microsoft SQL Servers available in the local area network:

Using System;
Using System.Collections.Generic;
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);
}
Console.ReadLine ();
}
}
}