Database Selection Via ComboBox

Question

I have a combobox that I would like to use to select the database from a selection available to the user. I have found plenty of information on populating the fields with table values but nothing on making a selection on which .dbo they can use. I'm guessing the same principle can be used as below... but I would presume that (database =) needs to be taken out and replaced some how. any advice would be appreciated

var connectionString = "server = (local); database = database; integrated security = true;"
string Sql = "select database...";
SqlConnection _con = new SqlConnection(connectionString);
_con.Open();
SqlCommand cmd = new SqlCommand(Sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
    combobox1.Items.Add(reader[0]);
}

Salah Akbari · Accepted Answer · 2016-10-11 08:29:13Z

2

You need this query;

string Sql = "SELECT * FROM sys.databases";

answered Oct 11, 2016 at 8:29

Salah Akbari

40k10 gold badges85 silver badges115 bronze badges

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

3 Comments

James Burnie Mcburnie Over a year ago

So its more down to what SQL query i send then? sorry the example didn't work, but that's more likely my end I Guess.

Salah Akbari Over a year ago

@JamesBurnieMcburnie What is your database? Isn't it SQL Server?

James Burnie Mcburnie Over a year ago

It is, sorry turns out its actually further up in my code and this isn't being executed at the right point causing it not to populate before it is shown to the User. Working now. Thank you

Vsevolod Okhrin · Accepted Answer · 2016-10-11 08:36:55Z

1

You can remove database option from connection string and execute sql query against master.dbo.sysdatabases.

Complete example:

var connectionString = "server=(local);integrated security=true;"
string sql = "SELECT name FROM master.dbo.sysdatabases";
SqlConnection conn= new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();

        while (reader.Read())
        {
            combobox1.Items.Add(reader["name"]);

        }

answered Oct 11, 2016 at 8:36

Vsevolod Okhrin

1114 bronze badges

Collectives™ on Stack Overflow

Database Selection Via ComboBox

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related