animated405
asked on
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!!
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!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much for your comments, not sure what to do so I'm splitting the points.
ASKER
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!!