public static List <BE_Mangueras> Listar_Mangueras_x_ID(BE_Mangueras pBE_Mangueras) { IDataReader DataReader = null; List <BE_Mangueras> oBE_Mangueras = new List <BE_Mangueras>(); try { SqlCommand cmd = (SqlCommand)db.GetStoredProcCommand("USP_SEL_MANGUERAS_X_ID"); db.AddInParameter(cmd, "@ID", DbType.String, pBE_Mangueras.ID); cmd.CommandTimeout = Convert.ToInt32(DuracionConexion.corta); using (DataReader = db.ExecuteReader(cmd)) { while (DataReader.Read()) { oBE_Mangueras.Add(new BE_Mangueras(DataReader, 2)); } } return(oBE_Mangueras); } catch (Exception ex) { throw ex; } finally { if (!DataReader.IsClosed) { DataReader.Close(); } } }
public static List <BE_Mangueras> Listar_Mangueras_x_ID(BE_Mangueras pBE_manguera) { try { return(DA_Mangueras.Listar_Mangueras_x_ID(pBE_manguera)); } catch (Exception ex) { throw ex; } }
private void Listar_Mangueras() { List <BE_Mangueras> Listar_Mangueras = new List <BE_Mangueras>(); pBE_mangueras = new BE_Mangueras(); pBL_mangueras = new BL_Mangueras(); Listar_Mangueras = BL_Mangueras.Listar_Mangueras(new BE_Mangueras()); this.cboMang.DataSource = Listar_Mangueras; this.cboMang.ValueMember = "Str_cod_mangueras"; this.cboMang.DisplayMember = "Str_cod_mangueras"; }