October 18, 2024 08:13 by
PeterWe'll be using SQL SMO(SQL Management Objects).
First of All, you need to add a reference to the Microsoft.SqlServer.smo.dll file which is located in.
- For 64-bit Windows 7:[Your drive]:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Smo.dll.
- For 32-bit Windows 7:[Your drive]:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Smo.dll.
Now that we've added it to our project, we can start coding!
Add a ListBox control to your project.
DataTable dataTable = SmoApplication.EnumAvailableSqlServers(true);
listBox1.ValueMember = "Name";
listBox1.DataSource = dataTable;
By running this code alone,you'll get all the available sql servers inside your listbox control.
Ok, let's develop it further. Let's see what databases our instances have. So to do this, you need to add another ListBox.Then in your listbox1's selectedindexchanged event, you need to check which server selected. So you need to create a server object first.
After this, you'll iterate through this server to populate all the databases in the newly created Listbox.
Here is the code to do that.
listBox2.Items.Clear();
if (listBox1.SelectedIndex != -1) {
string serverName = listBox1.SelectedValue.ToString();
Server server = new Server(serverName);
try {
foreach (Database database in server.Databases) {
listBox2.Items.Add(database.Name);
}
} catch (Exception ex) {
string exception = ex.Message;
}
}
After we run the project we'll be getting our Databases.
Hope it helps!
European Best, cheap and reliable ASP.NET hosting with instant activation. HostForLIFE.eu is #1 Recommended Windows and ASP.NET hosting in European Continent. With 99.99% Uptime Guaranteed of Relibility, Stability and Performace. HostForLIFE.eu security team is constantly monitoring the entire network for unusual behaviour. We deliver hosting solution including Shared hosting, Cloud hosting, Reseller hosting, Dedicated Servers, and IT as Service for companies of all size.
