Problem with DataTable

Hello, I'm getting data via an excel file that the user will upload through my application. I do not want to save the file, only grab the information (address book) and display with editable capabilities, so they can change errors I flag prior to submitting the information to the database.

I've built a wrapper class to represent an Address from the file. I get the information, put it into an array using my class (because I will want to do lots of checking the data), create a DataTable, and iterate through the array therby inserting each row into my memory table. (I'm also doing it this way because I want to add an auto incrimented field to reference each row)

I am able to do all this, display the data and I even understand how to make changes to it uses a postback method from this page, however what I really want to do is have the edit button pop-up a seperate window containing only the data corresponding to the ID from the DataTable row. Problem is I don't seem to have access to this data anymore on the new page...I thought that I DataTable was in the memory?!?!? Or is it only in memory for the original page? And if that's true, how does that page when it's refreshed still access the data in a way that a new page cannot?

It's too mush code to list here, and besides the data table works properly on the one page...I guess I'm just wondering why I don't have access to it elsewhere if it's in memory. Someone please help to explain. This is getting to be a very time sensitive matter for me.

thanks in advance!!
Who is Participating?
123654789987Connect With a Mentor Commented:
In a Web form it is able to use some kind of memory management to save the data of any of its control. But when u migrate to a different page this data is lost from memory. To store this data u have to explicitely cache the data or use Session to hold the data between forms.
animated405Author Commented:

thanks for the reply. So, basically on my first page I have to make the DataTable, populate it with my Data, then cache it. Then on my second page I have to grab it from memory, make a new datatable, repopulate it in order to get a specific row and edit that information, then reset it back to memory again so that when I return to the original page I can refresh with the updated data that was just put back into memory?

What do you mean explicitly cache the data or use session, what other method of caching the data is there besides using the session, hashtable or application states? And also, I haven't tried this but can you iterate through the cached session data just like you could through an array or something?

thanks again!!
jjacksnConnect With a Mentor Commented:
Session variable, animated, is what you had before

Session["yourvar"] = blah.

animated405Author Commented:

Thanks very much for your comments, not sure what to do so I'm splitting the points.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.