gridview翻页时 缓存不存在了,谢谢
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Session["StrName"] = "";
Session["StrAuth"] = "";
GridData();
}
/////////////
GridView1.PageIndex = e.NewPageIndex;
if (System.Web.HttpContext.Current.Cache["UserInfo"] != null)
{
Dv = (DataView)Cache["UserInfo"];
GridView1.DataSource = Dv;
GridView1.DataBind();
}
////////////////
private void GridData()
{
DataSet Ds;
DataView Dv;
if (System.Web.HttpContext.Current.Cache["UserInfo"] == null)
{
string myConn = System.Configuration.ConfigurationManager.ConnectionStrings["StoreConnectionString"].ConnectionString;
using (SqlConnection Con = new SqlConnection(myConn))
{
Ds = new DataSet();
SqlDataAdapter Da = new SqlDataAdapter("select UserId,UserName,UserPwd,UserAuth from UserInfo", Con);
Con.Open();
Da.Fill(Ds, "UserInfo");
Dv = Ds.Tables[0].DefaultView;
Dv.RowFilter = "UserName like '%" + Session["StrName"] + "%' and UserAuth like '%" + Session["StrAuth"] + "%'";
GridView1.DataSourceID = null;
}
Cache["UserInfo"] = Dv;
}
else
Dv = (DataView)Cache["UserInfo"];
GridView1.DataSource = Dv;
GridView1.DataBind();
}
///翻页后仍为真(System.Web.HttpContext.Current.Cache["UserInfo"] == null)