//Inicializa o dataset com as consultas que pertencem ao relatorio private DataSet initDsConsultas() { try { using (var ctx = new ReportContext()) { this.dsConsultasReport = new DataSet("dsReport"); ConnectionFactoryIts conn = new ConnectionFactoryIts(ctx.NameOrConnectionString, 90); foreach (var item in sourceReport) { var myTable = new DataTable(); myTable = conn.ExecuteQueryDataTable(item.Consulta.CorpoQuery); myTable.TableName = "table_" + item.Consulta.CodigoQuery; dsConsultasReport.Tables.Add(myTable); } return(dsConsultasReport); } } catch (Exception ex) { XMessageIts.ExceptionMessage(ex); return(null); } }
private void boundXGridTabDestino() { try { ConnectionFactoryIts conn = new ConnectionFactoryIts(AppConfigManager.Configuration.AppConfig.ConnectionString); DataTable dtTabelas = new DataTable("Tabelas"); dtTabelas = conn.ExecuteQueryDataTable("SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES"); gridControlTabDestino.DataSource = dtTabelas; } catch (SqlException ex) { LoggerUtilIts.ShowExceptionLogs(ex); } }
private void indexColumnsCbColDestino(string tableName) { try { var dtColumns = new DataTable("ColumnsDestino"); ConnectionFactoryIts cnn = new ConnectionFactoryIts(AppConfigManager.Configuration.AppConfig.ConnectionString); dtColumns = cnn.ExecuteQueryDataTable(String.Format("SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = {0}", "\'" + tableName + "\'")); foreach (var col in dtColumns.AsEnumerable()) { var colDest = new ColunaDestino(col[0].ToString(), col[1].ToString(), col[2].ToString(), col[3].ToString(), col[4].ToString()); repComboDestino.Items.Add(colDest); } } catch (SqlException ex) { LoggerUtilIts.ShowExceptionLogs(ex); } }