User-1164060753 posted
The original code uses an .ascx Control, which itself uses a TxtBox for User input and filtering, the GridView is inside an UpdatePanel and jQuery is used for triggering the UpdatePanel refresh upon User input, ecc... so it could be quite disguising...
So I have started from scratch, only using my BLL class to Get Data.
1 gridView with Paging, one ODS with/without CacheKeyDependency.
I haven't yet reproduced the twice Select calling behavior, however already with these simple code
there's something different which
happens enabling CacheKeyDependency.
Indeed, this could then be related to my problem (... or not?)
here is the code:
ASPX
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CacheKeyDependencyTwice.aspx.cs"
Inherits="WebSpace.Web.PagineProva.CacheKeyDependencyTwice" %>
<!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">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" DataSourceID="ODSData"
Width="60%">
</asp:GridView>
<asp:ObjectDataSource ID="ODSData" runat="server" EnableCaching="True" OldValuesParameterFormatString="original_{0}"
OnSelected="ODSData_Selected" OnSelecting="ODSData_Selecting" SelectMethod="GetRicambiWithDisponibilitaByDesc_WithoutParameters"
TypeName="WebSpace.BusinessLayer.BRicambi"></asp:ObjectDataSource>
</div>
</form>
</body>
</html>
C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Diagnostics;
namespace WebSpace.Web.PagineProva
{
public partial class CacheKeyDependencyTwice : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Debug.WriteLine(DateTime.Now.ToLongTimeString() + ": Page_Load");
}
protected void ODSData_Selected(object sender, ObjectDataSourceStatusEventArgs e)
{
Debug.WriteLine(DateTime.Now.ToLongTimeString() + ": ODSData_Selected");
}
protected void ODSData_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
Debug.WriteLine(DateTime.Now.ToLongTimeString() + ": ODSData_Selecting");
}
}
}
I Debug (F5) it, and change a couple of pages on the GridView.
Output:
'iisexpress.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\e1842388\72ad48b8\App_Theme_grids.rcldnk8g.dll', Symbols loaded.
14:39:23: Page_Load
14:39:23: ODSData_Selecting
14:39:24: ODSData_Selected
14:39:26: Page_Load
14:39:28: Page_Load
Then I enable
CacheKeyDependency="CacheKeyRicambi"
Output:
14:41:48: Page_Load
14:41:48: ODSData_Selecting
14:41:49: ODSData_Selected
14:41:51: Page_Load
14:41:51: ODSData_Selecting
14:41:51: ODSData_Selected
14:41:54: Page_Load
14:41:54: ODSData_Selecting
14:41:54: ODSData_Selected
