get list of databases in sql server based on sql instance enumeration

Question

I try to get the names of SQL databases in the server in this code I listed all sql instances in my computer in a combobox named sever using sqldatasource enumerator now I am trying to get the names of all sql databases names in the another combobox when I select a specific sql instance from server combobox but it doenot work

    private void Connect_Load(object sender, EventArgs e)
    {
        sqlservertable = sqlenumeratotr.GetDataSources();

         server.DataSource = sqlservertable;

         server.DisplayMember = sqlservertable.Columns["servername"].ToString();
         server.ValueMember = sqlservertable.Columns["servername"].ToString();


    }

    private void server_SelectedIndexChanged(object sender, EventArgs e)
    {
        servername = server.SelectedValue.ToString();
        constring = "server=servername;Integrated Security = sspi";
        SqlConnection con = new SqlConnection(constring);

        con.Open();
        dbltables = con.GetSchema("Databases");



        con.Close();
        databases.DataSource = dbltables;
        databases.DisplayMember = dbltables.Columns["database_name"].ToString();
    }

Community · Accepted Answer · 2017-05-23 12:12:55Z

3

If I understand the question correctly, I think that Heather's answer sufficiently addresses the question, I'll expand on it a bit.

You'll need to run the query that Heather mentioned, and then bind the results to the other ComboBox.

private void server_SelectedIndexChanged(object sender, EventArgs e)
{
    string serverName = server.SelectedValue.ToString();
    string connString = string.Format("server={0};Integrated Security = sspi", serverName);
    using (var con = new SqlConnection(connString))
    {
        using (var da = new SqlDataAdapter("SELECT Name FROM master.sys.databases", con))
        {
            var ds = new DataSet();
            da.Fill(ds);
            databases.DataSource = ds.Tables[0].Rows.Select(x => x["Name"].ToString());
            //...
        }
    }
}

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Nov 13, 2012 at 15:33

lukiffer

11.4k9 gold badges48 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martijn Pieters · Accepted Answer · 2012-11-13 08:13:29Z

2

select name from master.sys.databases

edited Nov 13, 2012 at 8:13

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered Nov 13, 2012 at 2:01

Heather

2,7021 gold badge24 silver badges34 bronze badges

2 Comments

Steve Wellens Over a year ago

I believe that is the sql statement you need to execute.

yat programmer Over a year ago

the problem is that I want to get all databases in combobox when i select the instance from another combobox

Collectives™ on Stack Overflow

get list of databases in sql server based on sql instance enumeration

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related