string key = "k_xxx";
string sql = "select * from xxx where xxx";
DataTable dt = HttpContext.Current.Cache[key] as DataTable;
if (dt == null)
{
dt = Dbl.CreateSqlDataTable(sql);
int iCount = dt.Rows.Count;
//批量修改字段
for (int i=0; i<iCount; i++)
{
dr.BeginEdit();
dr["nickName"] = "XXX";
dr.EndEdit();
}
dt.AcceptChanges();
HttpContext.Current.Cache.Insert(key, dt, null, DateTime.Now.AddSeconds(3600), System.Web.Caching.Cache.NoSlidingExpiration);
}