I have the following requirement:
On page load, Active orders should be displayed . I am using an ASP.NET gridview to display it.
Active Orders have active_flag=Y. I have to give the user an option to select inactive policies as well.
I wanted to query the DB once during page load and then display the Active policies only on page load.On selection of Inactive policies, Can data from the same dataset be used, without querying the databse again?
Please suggest a good way and code too .