Exemplo n.º 1
0
        private void btnShowDatabases_Click(object sender, EventArgs e)
        {
            DatabaseProvider provider = cbProvider.Text.ToEnum<DatabaseProvider>();

            if (provider == DatabaseProvider.SQLite)
            {
                OpenFileDialog ofd = new OpenFileDialog();
                ofd.CheckFileExists = false;
                if (ofd.ShowDialog() == DialogResult.OK)
                    txtDBName.Text = ofd.FileName;
            }
            else
            {
                Database.Database db = new Database.Database();
                db.SetConnectionString(provider, txtHost.Text, null, txtUserName.Text, txtPassword.Text);
                db.CreateDbProvider(false);

                ListBoxDialog lbd = new ListBoxDialog();
                lbd.ListBox.DataSource = db.GetDatabases();
                lbd.ListBox.SelectionMode = SelectionMode.One;
                lbd.Message = "Select a database";
                if (lbd.ShowDialog() == DialogResult.OK)
                    txtDBName.Text = lbd.GetSelectedItems<string>()[0];
            }
        }