DataTable dt = new DataTable(); if (Cache[ " mytablecache "] == null) { using (SqlConnection con = new SqlConnection( " Data Source=.;Initial Catalog=LocalDB;Integrated Security=True ")) { con.Open(); SqlDataAdapter adapter = new SqlDataAdapter( " SELECT top 100 * FROM [Money_CostDetail] ", con); adapter.Fill(dt); } Cache.Insert( " mytablecache ", dt, null, DateTime.UtcNow.AddMinutes( 1), TimeSpan.Zero); } else { dt = Cache[ " mytablecache "] as DataTable; }