public List <Tarjetas> getTodasTarjetas(String cedula) { EnviarCorreo e = new EnviarCorreo(); Conexion c = new Conexion(); SqlConnection con = new SqlConnection(); con = c.ObtenerConexion(); try { using (con) { SqlCommand cmd = new SqlCommand("targetasCliente", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cedula", cedula); SqlDataReader reader = cmd.ExecuteReader(); List <Tarjetas> tar = new List <Tarjetas>(); String num; while (reader.Read()) { Tarjetas pr = new Tarjetas(); pr.setNumtargeta(reader["NumTarjeta"].ToString()); tar.Add(pr); num = pr.getNumtargeta(); } con.Close(); return(tar); } } catch (Exception ex) { throw ex; } }