protected void CarregarDados(String owner, String tabela) { if (tabela.Length < 4 || tabela.Trim() == String.Empty) { lblvalidacao.Text = "Informe pelo menos 4 caracteres!"; return; } dvtabelas.Visible = false; dvcolunas.Visible = false; dvindices.Visible = false; dvconstraint.Visible = false; dvgrant.Visible = false; if (!CarregaTabelasPrincipais(owner, ref tabela)) { dvcolunas.Visible = true; dvindices.Visible = true; dvconstraint.Visible = true; dvgrant.Visible = true; var DataColumns = new dExecutorScripts().ObterColunasdaTabela(owner, tabela); var DataIndices = new dExecutorScripts().ObterIndicesdaTabela(owner, tabela); var DataConstraints = new dExecutorScripts().ObterConstraintsdaTabela(owner, tabela); var DataGrants = new dExecutorScripts().ObterGrantsTabela(owner, tabela); AssociarDadosGrid(dgcolunas, DataColumns, lblcoluna); AssociarDadosGrid(dgindices, DataIndices, lblindice); AssociarDadosGrid(dgconstraint, DataConstraints, lblconstraint); AssociarDadosGrid(dggrant, DataGrants, lblgrant); } }
protected bool CarregaTabelasPrincipais(string owner, ref string tabela) { bool bIndicaMaisdeUmRegistro = false; var DataTables = new dExecutorScripts().ObterTabela(owner, tabela); if (DataTables.Rows.Count == 0) { DataTables = new dExecutorScripts().ObterTabelas(owner, tabela); if (DataTables.Rows.Count > 1 || DataTables.Rows.Count == 0) { bIndicaMaisdeUmRegistro = true; dvtabelas.Visible = true; AssociarDadosGrid(dgtabelas, DataTables, lbltabelas); } else { //indica que encontrou somente um parecido tabela = (string)DataTables.Rows[0]["table_name"]; } } return bIndicaMaisdeUmRegistro; }
protected bool CarregaTabelasPrincipais(String owner, String tabela) { bool bIndicaMaisdeUmRegistro = false; var DataTables = new dExecutorScripts().ObterTabela(owner, tabela); if (DataTables.Rows.Count == 0) { bIndicaMaisdeUmRegistro = true; dvtabelas.Visible = true; AssociarDadosGrid(dgtabelas, DataTables, lbltabelas); } return bIndicaMaisdeUmRegistro; }