学步园

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);
}