示例#1
0
        private void btnTest_Click(object sender, EventArgs e)
        {
            ConnectionInfo connectionInfo = this.GetConnectionInfo();
            DbInterpreter  dbInterpreter  = DbInterpreterHelper.GetDbInterpreter(this.DatabaseType, connectionInfo, new GenerateScriptOption());

            try
            {
                using (DbConnection dbConnection = dbInterpreter.GetDbConnector().CreateConnection())
                {
                    dbConnection.Open();

                    MessageBox.Show("Success.");

                    if (string.IsNullOrEmpty(this.cboDatabase.Text.Trim()))
                    {
                        this.cboDatabase.Items.Clear();
                        List <Database> databaseses = dbInterpreter.GetDatabases();
                        databaseses.ForEach(item =>
                        {
                            this.cboDatabase.Items.Add(item.Name);
                        });
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed:" + ex.Message);
            }
        }
示例#2
0
        private async void btnTest_Click(object sender, EventArgs e)
        {
            ConnectionInfo connectionInfo = this.GetConnectionInfo();
            DbInterpreter  dbInterpreter  = DbInterpreterHelper.GetDbInterpreter(this.DatabaseType, connectionInfo, new DbInterpreterOption());

            string oldDatabase = this.cboDatabase.Text;

            try
            {
                using (DbConnection dbConnection = dbInterpreter.GetDbConnector().CreateConnection())
                {
                    dbConnection.Open();

                    MessageBox.Show("Success.");

                    this.cboDatabase.Items.Clear();

                    List <Database> databaseses = await dbInterpreter.GetDatabasesAsync();

                    databaseses.ForEach(item =>
                    {
                        this.cboDatabase.Items.Add(item.Name);
                    });

                    this.cboDatabase.Text = oldDatabase;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed:" + ex.Message);
            }
        }