public DataSet Request(DataSet ds, IncludeSchema isEnum, string nombreProcedimiento, IDictionaryEnumerator parametros) { DB2Connection lc = OpenConnection(); try { DB2Command comm = new DB2Command(nombreProcedimiento, lc); comm.CommandType = System.Data.CommandType.StoredProcedure; if (parametros != null) { while (parametros.MoveNext()) { comm.Parameters.Add(parametros.Key.ToString(), parametros.Value); } } DB2DataAdapter adapter = new DB2DataAdapter(comm); if (isEnum == IncludeSchema.YES) { adapter.FillSchema(ds, SchemaType.Mapped); adapter.Fill(ds); } else { adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString()); } } catch (Exception e) { exceptions = "Error ejecutando SQL." + cambioLinea + cambioLinea; exceptions += e.ToString(); AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Error, nombreProcedimiento, e, exceptions); } CloseConnection(lc); return(ds); }
public DataSet RequestGlobal(DataSet ds, IncludeSchema isEnum, string dataBase, string sql) { DB2Connection lc; if (dataBase == "") { lc = OpenConnectionGlobal(); } else { lc = OpenConnectionGlobal(dataBase); } try { AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Actividad, sql, null, string.Empty); DB2DataAdapter adapter = new DB2DataAdapter(sql, lc); if (isEnum == IncludeSchema.YES) { adapter.FillSchema(ds, SchemaType.Mapped); adapter.Fill(ds); } else { adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString()); } } catch { } CloseConnection(lc); return(ds); }
public DataSet Request(DataSet ds, IncludeSchema isEnum, string sql) { AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Actividad, sql, null, string.Empty); DB2DataAdapter adapter = new DB2DataAdapter(sql, connection); if (isEnum == IncludeSchema.YES) { adapter.FillSchema(ds, SchemaType.Mapped); adapter.Fill(ds); } else { adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString()); } return(ds); }
public DataSet Request(DataSet ds, IncludeSchema isEnum, string sql) { DB2Connection lc = OpenConnection(); try { AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Actividad, sql, null, string.Empty); DB2DataAdapter adapter = new DB2DataAdapter(sql, lc); if (isEnum == IncludeSchema.YES) { adapter.FillSchema(ds, SchemaType.Mapped); adapter.Fill(ds); } else { adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString()); } } catch (Exception z) { this.exceptions = z.Message; } CloseConnection(lc); return(ds); }
protected override DataTable BuildSchemaTable(Boolean withGeometryColumn) { DataTable dt = null; using (DB2Connection conn = new DB2Connection(ConnectionString)) { conn.Open(); conn.CacheData = true; using (DB2Command cmd = new DB2Command(string.Format("SELECT * FROM {0};", QualifiedTableName), conn)) { DB2DataAdapter da = new DB2DataAdapter(cmd); DataSet ds = new DataSet(); da.FillSchema(ds, SchemaType.Source); dt = ds.Tables["Table"]; } if (!withGeometryColumn) { dt.Columns.Remove(GeometryColumn); } } return(dt); }