How to save the DataTable for furhter access with .Net generics
Posted on 2012-08-19
Instead of accesing the database multiple times,I am storing the DataTable in ViewState.
DataTable dtSql = (DataTable) ViewState["tblxmlcol"];
On web page left menu links,when the link is clicked I am getting DataTable back from ViewState and accessing the Xml contents column and decoding it to Html.
It is slowing down the process.Is there any way can I make it faster.
Instead of storing the DataTable in ViewState and converting it to DataTable again can you suggest something using.Net generics or something else.