private void instancesComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
string server = (string)instancesComboBox.SelectedItem;
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.Add("Data Source", server);
builder.Add("Initial Catalog", "master");
builder.Add("Integrated Security", "SSPI");
using ( SqlConnection conn = new SqlConnection(builder.ConnectionString) )
{
SqlCommand cmd = new SqlCommand("select name from sys.databases", conn);
conn.Open();
using ( SqlDataReader reader = cmd.ExecuteReader() )
{
List<string> dbs = new List<string>();
while ( reader.Read() )
{
dbs.Add(reader.GetString(0));
}
dbsComboBox.DataSource = dbs;
}
}
}