Enable asp.net polling, DOT NET Programming

Assignment Help:

How to Enable ASP.NET polling?

All our database side is configured in order to get the SQL Cache working in the ASP.NET side we require to do some configuration in the web.config file.

The 2 attributes are require to set in the "web.config" file:-

  • Set the "Enabled" attribute to true to set the caching on.
  • Set the poll time attribute to the number of milliseconds between every poll

2415_asp.net polling.png

Figure :- Web.config file modifications for SQL cache

At last use the Cache dependency object in your ASP.NET code.

After that comes the final step to use our cache dependency with programmatic data caching,output caching  and data source control, .

For the programmatic data caching, we have to create a new SqlCacheDependency &  supply that to the Cache.Insert() process .  In the SqlCacheDependency constructor, you supply 2 strings. The first is the name of the database you defined in the element in the part of the web.config file e.g: Northwind. The second is the name of the linked table example: Products.

private static void CacheProductsList(List products) {SqlCacheDependency sqlDependency = new SqlCacheDependency("Northwind", "Products");

HttpContext.Current.Cache.Insert("ProductsList", products, sqlDependency, DateTime.Now.AddDays(1), Cache.NoSlidingExpiration);}

private static List GetCachedProductList()

{return HttpContext.Current.Cache["ProductsList"] as List;}

ClsProductItem is business class, and here we are trying to cache a list of ClsProductItem instead of DataSet or DataTable.

The following method is used by an ObjectDataSource Control to retrieve List of Products

 public static List GetProductsList(int catId, string sortBy)

{

//Try to Get Products List from the Cache

List products = GetCachedProductList();

if (products == null)

{

//Products List not in the cache, so query the Database layer

ClsProductsDB db = new ClsProductsDB(_connectionString);

DbDataReader reader = null;

products = new List(80);

if (catId > 0)

{

//Return Product List from the Data Layer

reader = db.GetProductsList(catId);

}

else {

//Return Product List from the Data Layer

reader = db.GetProductsList();

}

//Create List of Products -List if ClsProductItem-products = BuildProductsList(reader);

reader.Close();

//Add entry to products list in the Cache CacheProductsList(products); }

products.Sort(new ClsProductItemComparer(sortBy));

if (sortBy.Contains("DESC")) products.Reverse();

return products; }

To perform the same trick with output caching, you simply need to set the SqlDependency property with the database dependency name and the table name, separated by a colon:

<%@ OutputCache Duration="600" SqlDependency="Northwind:Products" VaryByParam="none" %>

The same technique works with the SqlDataSource and ObjectDataSource controls:

 


Related Discussions:- Enable asp.net polling

How to access view state value of the page in the next page?, How do we acc...

How do we access view state value of the page in the next page? The View state is page specific; it contains information about controls embedded at the particular page. ASP.NET

Explain the difference between xml and html., Explain the difference betwee...

Explain the difference between XML and HTML. XML explains data while HTML describes how the data should be displayed. Thus, HTML is about displaying information while XML is ab

Develop mobile web app, Project Description: This project uses Microsoft...

Project Description: This project uses Microsoft Visual Studio 2010/2012, Internet Information Services (IIS) Manager and Microsoft SQL Server Management Studio. It is a Mobi

Develop a simple .net software, I am seeking someone who can design customi...

I am seeking someone who can design customized software for me, preferably in .NET. I have a sql server backend which i would like to use so you only have to work with the front en

What is an il, What is an IL? Intermediate Language is also called as M...

What is an IL? Intermediate Language is also called as MSIL (Microsoft Intermediate Language) or CIL (Common Intermediate Language). All .NET source code is compiled to IL. IL

Metrics followed in project management, What are the metrics followed in pr...

What are the metrics followed in project management? The most metric sets deal with a variation of these attributes and are chosen to help the project managers gain insight int

What are attributes, What are Attributes?  Attributes are declarative t...

What are Attributes?  Attributes are declarative tags in code that insert additional metadata into an assembly. There exist two types of attributes in the .NET Framework: Prede

Converting temperature from fahrenheit to celsius in c#, Converting tempera...

Converting temperature from Fahrenheit to Celsius - Program C# I am facing some problems in the code for Converting temperature from Fahrenheit to Celsius. Can anybody suggest

State the differences between the dispose and finalize, State the differenc...

State the differences between the Dispose () and Finalize(). CLR uses the Dispose and Finalize methods to perform garbage collection of run-time objects of .NET applications.

Explain system workflow and a human workflow, What is the difference amonga...

What is the difference amonga system workflow and a human workflow? A system workflow is a workflow that is developed to automate interactions between applications. Such workfl

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd