实现Sql2005与页面的数据缓存

SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("select * from authors",conn);
SqlCacheDependency sqlDependency = new SqlCacheDependency(cmd);
this.GridView1.DataSource = cmd.ExcudeReader();
this.GridView1.DataBind();
conn.Close();

Response.AddCacheDependency(sqlDependency);
Response.Cache.SetValidUntilExpires(True);
Reponse.Cache.SetExpires(DateTime.Now.AddMinutes(60));