Evrardo
March 1st, 2007, 10:48 PM
I'm currently working on a web application which uses SQL Server 2005 and ASP.NET 2.0. I've implemented a sqlDataSource with caching enabled. I'm using CommandNotification as the sqlDependency, which means SQL Server tells the cache when data has changed in the database, hence expiring the items in the cache. I got this working just fine with my stored procedure. However, when I added a FilterExpression for my sqldatasource (added in the code behind the aspx page, the cache suddenly stopped refreshing.
Does anybody have any ideas as to why this would occur? I assume that FilterExpression simply wont work with CommandNotification. So is there anything I can do to filter my data without making another call to the database?
Oh, and my sqldatasource connects to a gridview to display the data.
Does anybody have any ideas as to why this would occur? I assume that FilterExpression simply wont work with CommandNotification. So is there anything I can do to filter my data without making another call to the database?
Oh, and my sqldatasource connects to a gridview to display the data.