private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { var columnas = FbObjetos.GetColumns(Padre.GetConnectionInformation(), comboBox1.Text); var misColumnas = columnas.Select("COLUMN_NAME <> ''"); var misc = misColumnas.Select(row => ((string)row["TABLE_NAME"] + "." + row["COLUMN_NAME"])).ToArray(); // checkedListBox1.DataSource = misc; }
private void cmbForeignTable_SelectedIndexChanged(object sender, EventArgs e) { var columnas = FbObjetos.GetColumns(Tabla.GetConnectionInformation(), cmbForeignTable.Text); var misColumnas = columnas.Select("COLUMN_NAME <> ''"); var misc = misColumnas.Select(row => ((string)row["COLUMN_NAME"])).ToArray(); // cmbForeignColumn.DataSource = misc; }
private void CreateView_Load(object sender, EventArgs e) { Vista = new MyView(); Vista.Inicializar(); var connectionData = Padre.GetConnectionInformation(); var tablas = FbObjetos.GetTables(connectionData); var misTablas = tablas.Select("TABLE_NAME <> ''"); var arrayTablas = misTablas.Select(row => ((string)row["TABLE_NAME"])).ToArray(); // comboBox1.DataSource = arrayTablas; }
private void CreateTrigger_Load(object sender, EventArgs e) { Trigger = new Trigger(); cmbTipo.DataSource = Enum.GetValues((typeof(TriggerType))); cmbEvento.DataSource = Enum.GetValues((typeof(TriggerEvent))); var connectionData = Padre.GetConnectionInformation(); var tablas = FbObjetos.GetTables(connectionData); var misTablas = tablas.Select("TABLE_NAME <> ''"); var arrayTablas = misTablas.Select(row => ((string)row["TABLE_NAME"])).ToArray(); // cmbTabla.DataSource = arrayTablas; }
private void TableForeignKey_Load(object sender, EventArgs e) { Llave = new ForeignKey(); foreach (var campo in Tabla.Tabla.Campos) { // cmbField cmbField.Items.Add(campo.Nombre); } // cmbField.DataSource = Tabla.Tabla.Campos; var connectionData = Tabla.GetConnectionInformation(); var tablas = FbObjetos.GetTables(connectionData); var misTablas = tablas.Select("TABLE_NAME <> ''"); var arrayTablas = misTablas.Select(row => ((string)row["TABLE_NAME"])).ToArray(); // cmbForeignTable.DataSource = arrayTablas; }
public void SetTreeValues(ConnectionData connData) { var tablas = FbObjetos.GetTables(connData); var dominios = FbObjetos.GetDomains(connData); var funciones = FbObjetos.GetFunctions(connData); var generadores = FbObjetos.GetGenerators(connData); var procedimientos = FbObjetos.GetProcedures(connData); var triggers = FbObjetos.GetTriggers(connData); var vistas = FbObjetos.GetViews(connData); //GETTING TABLES var misTablas = tablas.Select("TABLE_NAME <> ''"); var arrayTablas = misTablas.Select(row => new TreeNode((string)row["TABLE_NAME"])).ToArray(); // var treeNode = new TreeNode("Tablas", arrayTablas); treeView1.Nodes.Add(treeNode); foreach (TreeNode child in treeNode.Nodes) { //SETTIG COLUMNS TO EACH TABLE var a = child.Text; var col = FbObjetos.GetColumns(connData, a); var misCs = col.Select("COLUMN_NAME <> ''"); var arrayCols = misCs.Select(row => new TreeNode((string)row["COLUMN_NAME"])).ToArray(); // child.Nodes.Add(new TreeNode("Columnas", arrayCols)); //SETTIG primnary TO EACH TABLE var pri = FbObjetos.GetPrimaryKeys(connData, a); var misPri = pri.Select("COLUMN_NAME <> '' "); var arrPri = misPri.Select(row => new TreeNode((string)row["COLUMN_NAME"])).ToArray(); // child.Nodes.Add(new TreeNode("Primarias", arrPri)); //SETTIG INDEXES TO EACH TABLE var ind = FbObjetos.GetIndexes(connData, a); var misIn = ind.Select("INDEX_NAME <> '' AND IS_PRIMARY = FALSE"); var arrIn = misIn.Select(row => new TreeNode((string)row["INDEX_NAME"])).ToArray(); // child.Nodes.Add(new TreeNode("Indices", arrIn)); //SETTIG FOREIGN KEYS TO EACH TABLE var fora = FbObjetos.GetForeignKeys(connData); var misFora = fora.Select("CONSTRAINT_NAME <> '' AND TABLE_NAME ='" + a + "'"); var arrFora = misFora.Select(row => new TreeNode((string)row["CONSTRAINT_NAME"])).ToArray(); // child.Nodes.Add(new TreeNode("Foráneas", arrFora)); //SETTIG triggers KEYS TO EACH TABLE var tr = FbObjetos.GetTriggers(connData); var misTr = tr.Select("TRIGGER_NAME <> '' AND TABLE_NAME ='" + a + "' AND IS_SYSTEM_TRIGGER = 0"); var arrTr = misTr.Select(row => new TreeNode((string)row["TRIGGER_NAME"])).ToArray(); // child.Nodes.Add(new TreeNode("Triggers", arrTr)); } //GETTING DOMAINS var misDominios = dominios.Select("DOMAIN_NAME <> ''"); var arrayDominios = misDominios.Select(row => new TreeNode((string)row["DOMAIN_NAME"])).ToArray(); // treeNode = new TreeNode("Dominios", arrayDominios); treeView1.Nodes.Add(treeNode); //GETTING FUNCTIONS var misFunciones = funciones.Select("IS_SYSTEM_FUNCTION = 0 "); var arrayFunciones = misFunciones.Select(row => new TreeNode((string)row["FUNCTION_NAME"])).ToArray(); // treeNode = new TreeNode("Funciones", arrayFunciones); treeView1.Nodes.Add(treeNode); //GETTING GENERATORS var misGeneradores = generadores.Select("IS_SYSTEM_GENERATOR = 0"); var arrayGeneradores = misGeneradores.Select(row => new TreeNode((string)row["GENERATOR_NAME"])).ToArray(); // treeNode = new TreeNode("Generadores", arrayGeneradores); treeView1.Nodes.Add(treeNode); //GETTING PROCEDURES var misProcedimientos = procedimientos.Select("IS_SYSTEM_PROCEDURE = 0"); var arrayProcedimientos = misProcedimientos.Select(row => new TreeNode((string)row["PROCEDURE_NAME"])).ToArray(); // treeNode = new TreeNode("Procedimientos", arrayProcedimientos); treeView1.Nodes.Add(treeNode); //GETTING TRIGGERS var misTriggers = triggers.Select("IS_SYSTEM_TRIGGER = 0 "); var arrayTriggers = misTriggers.Select(row => new TreeNode((string)row["TRIGGER_NAME"])).ToArray(); // treeNode = new TreeNode("Triggers", arrayTriggers); treeView1.Nodes.Add(treeNode); //GETTING VIEWS var misVistas = vistas.Select("IS_SYSTEM_VIEW = 0"); var arrayVistas = misVistas.Select(row => new TreeNode((string)row["VIEW_NAME"])).ToArray(); // treeNode = new TreeNode("Vistas", arrayVistas); treeView1.Nodes.Add(treeNode); nuevoObejtoToolStripMenuItem.Enabled = true; foreach (TreeNode child in treeNode.Nodes) { //SETTIG COLUMNS TO EACH VIEW var a = child.Text; var col = FbObjetos.GetViewColumns(connData, a); var misCs = col.Select("COLUMN_NAME <> '' AND VIEW_NAME = '" + a + "'"); var arrayCols = misCs.Select(row => new TreeNode((string)row["COLUMN_NAME"])).ToArray(); // child.Nodes.Add(new TreeNode("Columnas", arrayCols)); } }