private void cargarProductoLista() { try { string ordenar = "order by p.[nombre] asc"; List <Producto> _cache = new List <Producto>(); string armadoDeQuery = "@familiaId in(" + familiaIdHiddenField.Value + ")"; string query = consultaSql(armadoDeQuery).SqlQuery(); _totalRows = ProductoBLL.SearchProductoPaginacion(ref _cache, query, Pager1.PageSize, Pager1.CurrentRow, ordenar); familiaForIdRepeater.DataSource = _cache; familiaForIdRepeater.DataBind(); Pager1.TotalRows = _totalRows; if (_cache.Count == 0) { noResult.Visible = true; Pager1.Visible = false; PagesButtons.Visible = true; return; } noResult.Visible = false; Pager1.Visible = true; Pager1.BuildPagination(); } catch (Exception ex) { log.Error("error al cargar la lista de articulos", ex); throw ex; //return; } }