Solved

Problem with DataTable

Posted on 2004-08-25
4
329 Views
Last Modified: 2010-04-15
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!!
0
Comment
Question by:animated405
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
123654789987 earned 250 total points
ID: 11899889
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.
0
 

Author Comment

by:animated405
ID: 11899936

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!!
0
 
LVL 5

Assisted Solution

by:jjacksn
jjacksn earned 250 total points
ID: 11899991
Session variable, animated, is what you had before

Session["yourvar"] = blah.

0
 

Author Comment

by:animated405
ID: 11902707

Thanks very much for your comments, not sure what to do so I'm splitting the points.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to measure sizes and angles in scanned images ? 3 52
What is Thread.Sleep? 5 45
Not showing page correctly 3 29
C#.NET and microsoft certification. 3 30
Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now