db connection

I have a database connection and have populated a dataset for a page. My question is can you pass the database connection to the next page? Can you use that same dataset on another page?

You can save your recordset object in a session variable and then read the session variable on the next page back in to a recordset.

If you save your dataset in a session make sure you convert it back to a dataset when you call it again.

VB Code:

ds = Ctype(Session("DS"), dataset)