i have a datatable with the results i just want to refine the results using this datatable... i am trying to do it but this datatable is distroyed each time page is refreshed......
A:
You can save the datatable in a session variable or cache
Cache.Insert("MyData1", datatable)
when the the page loads again you can check to see of the cache value is not equal to null. If its not you can use the value again.
ie.
Datatable Source;
Source = (Datatable)Cache["MyData1"];
Skiltz
2009-05-19 08:18:14
but using cache for a large datatable is a good option.. is it not any bad effect on my application...........
saurabh
2009-05-19 09:18:22
+1
A:
News flash: The web is stateless!
You would do well to look up "State management in ASP.NET".
Cerebrus
2009-05-19 08:55:07