i have a gridview on aspx page. in which data is almost unchanged for atleast 10 min, so i used sqlcache to improve performance. therefore i created a usercontrol like this.
<%@ OutputCache Duration="30" SqlDependency="intoro:Employee_Test" VaryByParam="none" %>
<asp:Button ID="Button1" runat="server" Text="SHOW" OnClick="Button1_Click" /><br />
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
code behind for this usercontrol is
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(str);
con.Open();
SqlCommand cmd = new SqlCommand("select * from Employee_Test", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
...
Go to the complete details ...