title: How to save Dataset in temp memory of page?
body: <p>I have a function which call a procedure from SQL Server and return a datatable as </p>
  
  <pre><code>public static DataTable GetProducts(int parmCategory = -1){}
  </code></pre>
  
  <p>in my asp page I have</p>
  
  <pre><code> ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", ReportsBLL.GetProducts()));
   ReportViewer1.LocalReport.Refresh();
  </code></pre>
  
  <p>which fill once in <code>pageload()</code>
  this procudure takes about 8 minutes to get data from database 
  and I want to make a lot of filtration in button press to filter data which comes from <code>GetProducts</code> 
  and there is no logic to call procure in every filter and contact the DB</p>
  
  <p>So, how can I save the data once I get it in the <code>pageload</code> and deal with it in button press filtration   </p>