SQL instance Listing in ComboBox

[John Barr]

Does anyone know how to search for Instances of SQL Server running on your network through code to populate a drop down like is done in the SQL Server Query Analyzer, and then once an instance is selected, list the databases on that Instance?

[Nicholas Paldino [.NET/C# MVP]]

John,

In order to do this, you have a number of options.

To get the list of SQL server instances on the network, you can call the
NetServerEnum function through the P/Invoke layer. It will allow you to
return a list of SQL server instances on your network. Also, you can use
the SQLDMO library through COM interop. There is a COM class that has a
method that will do this (although the name escapes me).

Once you have the names of your SQL servers, you can use the classes in
the System.Data.Sql Client namespace to connect to the database and then
issue queries against the system tables to get the databases on the
instance. Also, you can set a reference to the ADOX library to do the same
thing through an object-oriented model.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"John Barr" <jb***@toobrand s.com> wrote in message
news:D3******** *************** ***********@mic rosoft.com...

Does anyone know how to search for Instances of SQL Server running on your

network through code to populate a drop down like is done in the SQL Server
Query Analyzer, and then once an instance is selected, list the databases on
that Instance?

[Roberto Martinez-Brunet]

Like in

http://www.codeproject.com/csharp/servercombobox.asp

R-o

[Deming He]

John Barr <jb***@toobrand s.com> wrote in message
news:D3******** *************** ***********@mic rosoft.com...

Does anyone know how to search for Instances of SQL Server running on your

network through code to populate a drop down like is done in the SQL Server
Query Analyzer, and then once an instance is selected, list the databases on
that Instance?

RegistryKey RK;
RK =
egistry.LocalMa chine.OpenSubKe y( "HKEY_LOCAL_MAC HINE\\SOFTWARE\ \Microsoft\\M
icrosoft SQL Server" );
Console.WriteLi ne(Convert.ToSt ring(RK.GetValu e("InstalledIns tances")));

You do need to parse the value return before populating your list box.