Loading all database into combo box and loading all sqlsever name in C# .Net

Loading database into combobox as well server name that are available...

Import reference:

//This is available in sql sever SDK Folder

Microsoft.SqlServer.ConnectionInfo

Microsoft.SqlServer.Smo

//Use namespace to import.

using Microsoft.SqlServer.Management.Smo;

using Microsoft.SqlServer.Management.Common;

Declare Object of Server Class

Code in load event of form:

        //datatable object

 

        DataTable dt = SmoApplication.EnumAvailableSqlServers(true);

        if (dt.Rows.Count > 0)

        {

            // Loop through each server in the DataTable

            foreach (DataRow dr in dt.Rows)

            {

 

                //cmbsrv_name is name of combo box in //which all server name will be loaded..

                cmbsrv_name.Items.Add(dr["Name"]);

            }

        }

To load all database code:

This code will be in button click event to connect with server.

//cmbsrv_name is name of combo in which all server name loaded.

 

        if (cmbsrv_name.SelectedItem != null && cmbsrv_name.SelectedItem.ToString() != "")

        {

            ServerConnection srvcon = new ServerConnection(cmbsrv_name.SelectedItem.ToString());

            srvcon.LoginSecure = false;

 

            //txtuserid is id of server and txtpassword password of server to connect

            srvcon.Login = txtuserid.Text;

            srvcon.Password = txtPassword.Text;

            srv = new Server(srvcon);

            foreach (Database db in srv.Databases)

            {

                //cmbdatabase is name of combobox in which all database related to that server will be loaded

 

                cmbDatabase.Items.Add(db.Name);

            }

        }

Thanks you

Ebook Download
View all
Learn
View all