How to enable cache in Gridview ?



Hi
Using SqldataSource or ObjectdataSource control, we can easily implement the cache concept in Gridview. If we will use the cache concept,it will avoid the server overloading and it will increase the performance of website.

We can do like this.Here i m using objectdatasource.
Step1:Create one Class i.e “GetEmp” and write the code like this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Web.Configuration;

///

/// Summary description for GetEmp
///

public class GetEmp
{
private static readonly string _ConnectionString;
public int Id { get; set; }
public string EmpName { get; set; }
public string EmpSal { get; set; }

static GetEmp()
{
_ConnectionString = WebConfigurationManager.ConnectionStrings[“Test”].ConnectionString;
}

public List GetAllEmp()
{
List result = new List();
using (SqlConnection con = new SqlConnection(_ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(“Select Id,Empname,EmpSal from tblEmp”, con))
{
using (con)
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
GetEmp newEmp = new GetEmp();
newEmp.Id = (int)dr[“Id”];
newEmp.EmpName = (string)dr[“EmpName”];
newEmp.EmpSal = (string)dr[“EmpSal”];
result.Add(newEmp);

}

}
}
return result;
}
}
}

Step2: Take one Gridview and ObjectDatasouce Control in default page like this.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="ObjectDataSource1" CellPadding="4" ForeColor="#333333">
<RowStyle BackColor="#E3EAEB" />
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" SortExpression="Id" />
<asp:BoundField DataField="EmpName" HeaderText="EmpName"
SortExpression="EmpName" />
<asp:BoundField DataField="EmpSal" HeaderText="EmpSal"
SortExpression="EmpSal" />
</Columns>
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#7C6F57" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<br />
<asp:ObjectDataSource ID="ObjectDataSource1" TypeName="GetEmp" EnableCaching="true" CacheDuration="3000" SelectMethod="GetAllEmp" runat="server">
</asp:ObjectDataSource>

Step3:Now Compile the code.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: