urgent: getting data out of a dataset in different subs

[gd082]

I filled a dataset in my page_load sub from an sql-server db. Now i want to extract that same information from my dataset into a variable but in a different sub (for example.. in a clickevent of a button).
Where and how must i declare my dataset to be able to access the data in it everywhere on my webform?

please help

 

[jfrost10]

You have to assign it to a session variable. What you should do in your page load is this:

Private Sub PageLoad()

If Not Page.IsPostBack 'only fires on first page load
'Insert code here to fill the dataset. Once you have it...
Session("DataSet&quot = objDataSetYouCreatedAndFilled
End If

End Sub

Now, you just have to access the Session("DataSet&quot variable and you can get at the data from anywhere in your code.

Any other questions, just ask


Jack

 

[gd082]

thnxs for your help !!

But Can I Use the following statement when i put my dataset in an session variable:

session("dataset&quot.tables("....&quot.rows(0).item("...&quot

just like i did to extract data from the original dataset?

 

[jfrost10]

Yeah, you can still use it. Session variables don't utilize Intellisense though, which means you won't have those drop downs appearing to prompt you for what comes next.

It looks like you've got the syntax down anyway though, so you shouldn't have any probs.

Jack

 

[gd082]

Thanks for your help!