我的代码 private void picNewSee()
{
OleDbConnection Conn = db.CreateConnection();
Conn.Open(); string stringSQL = "Select top 8 * From picTable where tops='True' Order BY id desc";
OleDbDataAdapter rs = new OleDbDataAdapter(stringSQL,Conn); DataSet dseName = new DataSet();
rs.Fill(dseName,"infList"); PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dseName.Tables["infList"].DefaultView;
picNewWeb.DataSource = objPage;
picNewWeb.DataBind();
Conn.Close();
}
找来的代码
public DataSet createCache()
{
//返回DataSet
DataSet ds=new DataSet();
OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source="+Server.MapPath("data.mdb"));
conn.Open();
string sql="select * from data1 order by createtime asc";
OleDbDataAdapter cmd=new OleDbDataAdapter(sql,conn);
cmd.Fill(ds);
cmd.Dispose();
conn.Dispose();
return ds;
//建立Cache
if(Cache["DataList"]==null)
{
//缓存不存在建立缓存
Cache.Insert("DataList",(DataSet)createCache());
DataSet ds=(DataSet)Cache["DataList"];
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}
else
{
//缓存存在执行绑定
DataSet ds=(DataSet)Cache["DataList"];
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}
}如何把我找来的代码应用到我的代码中呢?
{
OleDbConnection Conn = db.CreateConnection();
Conn.Open(); string stringSQL = "Select top 8 * From picTable where tops='True' Order BY id desc";
OleDbDataAdapter rs = new OleDbDataAdapter(stringSQL,Conn); DataSet dseName = new DataSet();
rs.Fill(dseName,"infList"); PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dseName.Tables["infList"].DefaultView;
picNewWeb.DataSource = objPage;
picNewWeb.DataBind();
Conn.Close();
}
找来的代码
public DataSet createCache()
{
//返回DataSet
DataSet ds=new DataSet();
OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source="+Server.MapPath("data.mdb"));
conn.Open();
string sql="select * from data1 order by createtime asc";
OleDbDataAdapter cmd=new OleDbDataAdapter(sql,conn);
cmd.Fill(ds);
cmd.Dispose();
conn.Dispose();
return ds;
//建立Cache
if(Cache["DataList"]==null)
{
//缓存不存在建立缓存
Cache.Insert("DataList",(DataSet)createCache());
DataSet ds=(DataSet)Cache["DataList"];
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}
else
{
//缓存存在执行绑定
DataSet ds=(DataSet)Cache["DataList"];
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}
}如何把我找来的代码应用到我的代码中呢?
{
if(Cache["DataList"]==null) // 如果Cache不存在就建立 { // OleDbConnection Conn = db.CreateConnection();
Conn.Open(); string stringSQL = "Select top 8 * From picTable where tops='True' Order BY id desc";
OleDbDataAdapter rs = new OleDbDataAdapter(stringSQL,Conn); DataSet dseName = new DataSet();
rs.Fill(dseName,"infList");
Cache["DataList"]=dseName; //把DATASET放进Cache;
}
esle //如果Cache存在就直接使用Cache中的DataSet
{
DataSet dseName = (DataSet)Cache["DataList"];}//下面调用数据绑定
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dseName.Tables["infList"].DefaultView;
picNewWeb.DataSource = objPage;
picNewWeb.DataBind();
Conn.Close();
}
你的代码没有效果啊