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?
Printable View
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)