VB.net sharing Dataset between different Classes

hi, right now i m creating a webpage with different pages

i want all the pages to have one dataset that contains data from a table in SQL server

i wonder if it is possible to just make one connection in one class and fill the dataset with the data from the SQL server

and have all the other classes uses that dataset

[341 byte] By [nonamehero] at [2007-12-31]
# 1
use cache.
LauHanChing at 2007-9-7 > top of Msdn Tech,Visual Basic,Visual Basic Language...
# 2

ASP.NET exposes a number of different caching options for you to consider.

Here's an article that may prove helpful for what you seem to want to acheive ...

http://msdn.microsoft.com/msdnmag/issues/03/04/WickedCode/default.aspx

It's a bit old but should help to get you started ... just do some more reading about ASP2.0 caching before you start coding.

Richard

DickDonny at 2007-9-7 > top of Msdn Tech,Visual Basic,Visual Basic Language...