Exemple #1
0
        private void btRefresh_Click(object sender, System.EventArgs e)
        {
            if (tvSchemaView.Nodes.Count == 0)
            {
                BuildTree();
            }
            else
            {
                if (!this.pnRestrict.Visible)
                {
                    return;
                }

                DataTable dtFromProp  = ((DataRowView)this.propertyGrid.SelectedObject).DataView.Table;
                int       restrNumber = dtFromProp.Columns.Count;
                string[]  restrArray  = new string[restrNumber];

                for (int i = 0; i < restrNumber; i++)
                {
                    if (dtFromProp.Rows[0][i].ToString() != "")
                    {
                        restrArray[i] = dtFromProp.Rows[0][i].ToString();
                    }
                }

                this.dgShowMeta.DataSource = connection.GetSchema(dtFromProp.TableName, restrArray);
            }
        }
Exemple #2
0
        private void cbDatabase_DropDown(object sender, System.EventArgs e)
        {
            if (sqlConnection.State == System.Data.ConnectionState.Closed)
            {
                sqlConnection.Schema = "public";
                sqlConnection.Open();
            }

            cbDatabase.Items.Clear();
            DataTable databases = sqlConnection.GetSchema("Databases");

            foreach (DataRow row in databases.Rows)
            {
                cbDatabase.Items.Add(row[0]);
            }
        }