DataSet Question
I have a data set question which may seem stuipid, but maybe someone can shed some light.
I have a data set that is populated in my Page_Load event. I want to resuse this data set again in another event, however the rowcount is 0. I don't want to have to run the query and fill it again if possible.
I created the dataset through the IDE, I assumed(bad idea) that it would be global to the page and available at any time. I even tried changing the data set declaration from:
Protected WithEvents DsCallCategories1 As CallBoxTEST.dsCallCategories
To:
Public WithEvents DsCallCategories1 As CallBoxTEST.dsCallCategories
How can I create a data set, fill it once, and use it continuously thoroughout the page? Would I need to cache it? Could I create it in the Global.asax and create and destroy as necessary?
Thanks for any help and ideas!!!
Jim
|