public DataTable LoadTable(string storedProcedureName) { DataTable dtTable = new DataTable(); DBProvider database = new DBProvider(rutaContratos, "System.Data.SqlClient"); DbCommand command = database.GetStoredProcCommand(storedProcedureName); dtTable.Load(database.ExecuteReader(command)); return(dtTable); }
public IDataReader ExecuteReaderV2(string storedProcedureName, Dictionary<string, object> parameters) { DBProvider database = new DBProvider(rutaContratos, "System.Data.SqlClient"); DbCommand command = database.GetStoredProcCommand(storedProcedureName); foreach (KeyValuePair<string, object> parameter in parameters) { database.AddInParameter(command, parameter.Key, parameter.Value); } IDataReader dr = database.ExecuteReader(command); return dr; }
public IDataReader ExecuteReader(string storedProcedureName, Dictionary <string, object> parameters) { DBProvider database = new DBProvider(rutaContratos, "System.Data.SqlClient"); DbCommand command = database.GetStoredProcCommand(storedProcedureName); foreach (KeyValuePair <string, object> parameter in parameters) { database.AddInParameter(command, parameter.Key, parameter.Value); } IDataReader dr = database.ExecuteReader(command); return(dr); }
public DataTable LoadTable(string storedProcedureName, Dictionary <string, object> parameters) { DataTable dtTable = new DataTable(); DBProvider database = new DBProvider(rutaContratos, "System.Data.SqlClient"); DbCommand command = database.GetStoredProcCommand(storedProcedureName); foreach (KeyValuePair <string, object> parameter in parameters) { database.AddInParameter(command, parameter.Key, parameter.Value); } dtTable.Load(database.ExecuteReader(command)); return(dtTable); }
public DataTable LoadTable(string storedProcedureName) { DataTable dtTable = new DataTable(); DBProvider database = new DBProvider(rutaContratos, "System.Data.SqlClient"); DbCommand command = database.GetStoredProcCommand(storedProcedureName); dtTable.Load(database.ExecuteReader(command)); return dtTable; }
public DataTable LoadTable(string storedProcedureName, Dictionary<string, object> parameters) { DataTable dtTable = new DataTable(); DBProvider database = new DBProvider(rutaContratos, "System.Data.SqlClient"); DbCommand command = database.GetStoredProcCommand(storedProcedureName); foreach (KeyValuePair<string, object> parameter in parameters) { database.AddInParameter(command, parameter.Key, parameter.Value); } dtTable.Load(database.ExecuteReader(command)); return dtTable; }