private DataSet FillGrid() { SqlQueryChecker.Check(model.ReportSettings.CommandType, model.ReportSettings.CommandText); DataSet dataSet = ResultPanel.CreateDataSet(); this.txtSqlString.Text = model.ReportSettings.CommandText; var dataAccess = new SqlDataAccessStrategy(model.ReportSettings); switch (model.ReportSettings.CommandType) { case CommandType.Text: dataSet = DataSetFromSqlText(dataAccess); break; case CommandType.StoredProcedure: dataSet = DataSetFromStoredProcedure(dataAccess); break; case CommandType.TableDirect: MessageService.ShowError("TableDirect is not suppurted at the moment"); break; default: throw new Exception("Invalid value for CommandType"); } return(dataSet); }
private DataSet FillGrid() { this.connectionObject = ConnectionObject.CreateInstance(this.model.ReportSettings.ConnectionString, System.Data.Common.DbProviderFactories.GetFactory("System.Data.OleDb")); this.txtSqlString.Text = String.Empty; SqlQueryChecker.Check(model.ReportSettings.CommandType, model.ReportSettings.CommandText); DataSet dataSet = ResultPanel.CreateDataSet(); switch (model.ReportSettings.CommandType) { case CommandType.Text: this.txtSqlString.Text = model.ReportSettings.CommandText; dataSet = BuildFromSqlString(); break; case CommandType.StoredProcedure: MessageService.ShowError("Stored Procedures are not suppurted at the moment"); break; case CommandType.TableDirect: MessageService.ShowError("TableDirect is not suppurted at the moment"); break; default: throw new Exception("Invalid value for CommandType"); } if (model.ReportSettings.CommandType == CommandType.StoredProcedure) { /* * if (reportStructure.SharpQueryProcedure == null) { * throw new IllegalQueryException(); * } * * SharpQueryProcedure procedure = reportStructure.SharpQueryProcedure; * SharpQuerySchemaClassCollection sc = procedure.GetSchemaParameters(); * * if ((sc != null) && sc.Count > 0) { * dataSet = ExecuteStoredProc (procedure); * }else { * dataSet = ExecuteStoredProc (); * } */ } // from here we create from an SqlString like "Select...." // if (model.ReportSettings.CommandType == CommandType.Text){ // this.txtSqlString.Text = model.ReportSettings.CommandText; // dataSet = BuildFromSqlString(); // } return(dataSet); }
private DataSet FillGrid() { this.connectionObject = ConnectionObject.CreateInstance(this.model.ReportSettings.ConnectionString, System.Data.Common.DbProviderFactories.GetFactory("System.Data.OleDb")); this.txtSqlString.Text = String.Empty; SqlQueryChecker.Check(model.ReportSettings.CommandType, model.ReportSettings.CommandText); DataSet dataSet = ResultPanel.CreateDataSet(); this.txtSqlString.Text = model.ReportSettings.CommandText; if (model.ReportSettings.CommandType == CommandType.StoredProcedure) { if (reportStructure.SharpQueryProcedure == null) { throw new IllegalQueryException(); } SharpQueryProcedure procedure = reportStructure.SharpQueryProcedure; SharpQuerySchemaClassCollection sc = procedure.GetSchemaParameters(); if ((sc != null) && sc.Count > 0) { dataSet = ExecuteStoredProc(procedure); } else { dataSet = ExecuteStoredProc(); } } // from here we create from an SqlString like "Select...." if (model.ReportSettings.CommandType == CommandType.Text) { this.txtSqlString.Text = model.ReportSettings.CommandText; dataSet = BuildFromSqlString(); } return(dataSet); }