예제 #1
0
        /// <summary>
        /// Loads the grid and column list controls according to the specified query
        /// </summary>
        /// <param name="sSQL"></param>
        private void LoadQueryRecords(string sSQL)
        {
            if (sSQL.Trim() == string.Empty)
            {
                MessageBox.Show("The SQL query was empty!  Please enter a valid SQL query!");
                return;
            }

            try
            {
                Cursor.Current = Cursors.WaitCursor;

                m_TableInfo            = DatabaseUtilities.LoadDataTable(m_sSqlConnectionString, cmbDatabases.Text, sSQL);
                dgTableInfo.DataSource = m_TableInfo;

                // load the list of columns to include in the generator
                chklstIncludeFields.Items.Clear();
                foreach (DataColumn col in m_TableInfo.Columns)
                {
                    // exclude the primary/auto-increment key by default, but select/check all the others
                    chklstIncludeFields.Items.Add(col.ColumnName, (chklstIncludeFields.Items.Count > 0));
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("LoadQueryRecords error: " + ex.Message);
            }
            finally
            {
                Cursor.Current = Cursors.Default;
                UpdateControls();
            }
        }
예제 #2
0
        private void cmbDatabases_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cmbDatabases.SelectedIndex < 0)
            {
                return;
            }

            // user selected a different database, so load the table combobox
            try
            {
                Cursor.Current       = Cursors.WaitCursor;
                cmbTables.DataSource = null;
                cmbTables.Items.Clear();
                cmbTables.DisplayMember = "TableSchemaAndName";
                cmbTables.ValueMember   = "TableSchemaAndName";

                DataTable dt = DatabaseUtilities.GetDatabaseTables(m_sSqlConnectionString, cmbDatabases.Text);
                cmbTables.DataSource = dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show("cmbDatabases_SelectedIndexChanged error: " + ex.Message);
            }
            finally
            {
                Cursor.Current = Cursors.Default;
                UpdateControls();
            }
        }
예제 #3
0
        /// <summary>
        /// Initializes the database combobox control
        /// </summary>
        private void InitializeDatabaseControls()
        {
            try
            {
                Cursor.Current = Cursors.WaitCursor;

                cmbDatabases.DataSource = null;
                cmbDatabases.Items.Clear();
                cmbTables.DataSource = null;
                cmbTables.Items.Clear();     // clear the tables also since they'll be invalid

                cmbDatabases.DisplayMember = "DATABASE_NAME";
                cmbDatabases.ValueMember   = "DATABASE_NAME";
                DataTable dt = DatabaseUtilities.GetDatabases(m_sSqlConnectionString);
                cmbDatabases.DataSource = dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error loading database-tables into list: " + ex.Message);
            }
            finally
            {
                Cursor.Current = Cursors.Default;
                UpdateControls();
            }
        }