This is a migrated thread and some comments may be shown as answers.

Radlistview and data caching

1 Answer 114 Views

ListView

This is a migrated thread and some comments may be shown as answers.

Fabio Cirillo asked on 08 Mar 2013, 10:53 AM

hi,
I'm using a radlistview with raddatapager to view the selected records in a database after a search. Now so that when you click on raddatapager to see the records in the listview, it should retry the connection to the database and re-run the query select sql, I thought of using the data caching using the method OutputCache. Obviously use the OutputCache only if they do not change the search parameters. But now I have a problem that I set the radlistview to 10 records per page, load 25 records, I have 3 pages to be displayed, using the OutputCache when licco DataPager on arrival to the second page and then stops do not go forward. I thought of setting the html code on the page this parameter: <% @ OutputCache duration = "300" VaryByParam = "_str1, _str2, RadDataPager1"%>, but nothing does not work. send time is the html code of the page, and the code vb net.

html code:

<%@ Page Language="vb" AutoEventWireup="false" CodeFile="search.aspx.vb" Inherits="search" %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>

<%@ OutputCache duration="600" VaryByParam="_str1,_str2,RadListView1" %>

<%@ Import Namespace="TRYcontact" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<meta name="description" content="Trycontact; il social network che ti collega alla community con il tuo biglietto da visita virtuale." />

<link href="App_Themes/TryCss/chrome.css" rel="stylesheet" type="text/css" />

<title>TRYcontact: risultati della ricerca</title>

<script type="text/javascript">

// prendo valore div contenitore radlistview

function Height_Div() {

var _heightdiv1 = document.getElementById("div_radlistview").offsetHeight;

var _positiondiv2 = document.getElementById("under");

//_positiondiv2.style.top = (_heightdiv1) + "px";

}

function DoPostBack() {

__doPostBack();

}

</script>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="ImageButtonRicerca">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="Panel1"

LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadListView1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadWindowCard"

LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadNotification ID="RadNotification1" runat="server" Height="100px"

Skin="Simple" TitleIcon="~/Image/iconlogo.png" Width="400px"

AutoCloseDelay="3500" Position="Center" Title="Notifica trycontact">

</telerik:RadNotification>

<asp:HiddenField ID="_search" runat="server" /><asp:HiddenField ID="_search1" runat="server" />

<telerik:RadFormDecorator ID="RadFormDecorator" Runat="server"

DecoratedControls="Default, Textbox, Textarea, Label, H4H5H6, Select, Zone, GridFormDetailsViews, ValidationSummary, LoginControls"

Skin="Sunset" />

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server"

BorderColor="#D5842B" BorderStyle="Double" BorderWidth="1px" Skin="Simple">

</telerik:RadAjaxLoadingPanel>

<div align="center" class="backgroundup">

<div align="center" class="banner">

<div style="padding-left:200px;">

<div class="profilesearch">

<asp:Panel ID="Panel1" runat="server" DefaultButton="ImageButtonRicerca" Height="55px" Width="685">

<div id="txt1" style="width:350px; height:22px; border:0px; margin:0px; padding-top:15px; padding-right:1px; float:left">

<telerik:RadTextBox ID="Txt_ricerca1" Runat="server"

EmptyMessage="Nominativo o azienda o categoria" Width="350px" Height="22px" Skin="" Font-Italic="True"

Font-Names="Verdana">

<EmptyMessageStyle ForeColor="Gray" Font-Italic="True" Font-Names="Verdana" />

<HoveredStyle Font-Italic="True" Font-Names="Verdana" ForeColor="#993300" />

</telerik:RadTextBox>

</div>

<div id="txt2" style="width:250px; height:22px; border:0px; margin:0px; padding-top:15px; padding-right:1px; float:left">

<telerik:RadTextBox ID="txt_ricerca2" runat="server"

EmptyMessage="Città di residenza" Width="250px" Height="22px" Skin=""

Font-Italic="True" Font-Names="Verdana">

<EmptyMessageStyle ForeColor="Gray" Font-Italic="True" Font-Names="Verdana" />

<HoveredStyle Font-Italic="True" Font-Names="Verdana" ForeColor="#993300" />

</telerik:RadTextBox>

</div>

<div id="btn" style="width:80px; height:40px; border:0px; margin:0px; padding-top:7px; float:right">

<asp:ImageButton ID="ImageButtonRicerca" runat="server"

ImageUrl="~/Image/search.png" Width="48px" />

</div>

</asp:Panel>

</div>

<div id="menu" class="divresultmenu">

<div class="divbuttonmenu">

<telerik:RadButton ID="btnhome" runat="server" Text="Home page" Width="80px" Skin="Office2010Silver">

</telerik:RadButton>

<telerik:RadButton ID="btnreg" runat="server" Text="Registrati in trycontact" Width="180px" Skin="Office2010Silver">

</telerik:RadButton>

</div>

</div> 

<div class="resultseparator">

<asp:Label ID="Label1" runat="server" class="lbresult" Text="Biglietti da visita trovati:"

style="font-size: x-small; font-family: Verdana" ForeColor="#999999"></asp:Label>

</div> 

<asp:Panel ID="PanelRadlist" runat="server" Width="700px">

<div id="div_radlistview" class="divradlistview">

<telerik:RadListView ID="RadListView1" runat="server" DataKeyNames="idutente"

ItemPlaceholderID="Contenitore" AllowPaging="True"

Width="650px" >

<LayoutTemplate>

<fieldset style="width: 700px; border:0px" id="FieldSet1">

<legend></legend>

<asp:Panel ID="Contenitore" runat="server">

</asp:Panel>

<telerik:RadDataPager ID="RadDataPager1" runat="server"

PagedControlID="RadListView1" Width="700px" Culture="it-IT" BackColor ="#ecede5">

<Fields>

<telerik:RadDataPagerButtonField FieldType="FirstPrev"></telerik:RadDataPagerButtonField>

<telerik:RadDataPagerButtonField FieldType="Numeric"></telerik:RadDataPagerButtonField>

<telerik:RadDataPagerButtonField FieldType="NextLast"></telerik:RadDataPagerButtonField>

</Fields>

</telerik:RadDataPager>

</fieldset>

</LayoutTemplate>

<ItemTemplate>

<div class="item">

<div class="image">

<asp:Image ID="Image1" runat="server" ImageUrl='<%# CType(Container.DataItem, PropertyUtente).imageprofile%>' Height="120px" Width="110px"/>

</div>

<div class="content">

<div class="user">