Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Chaching Dataset using session object

Posted on 2004-08-22
3
Medium Priority
?
219 Views
Last Modified: 2010-04-17

Hello, new to .Net. I would like to cache a dataset to the session object because the data is coming from a file the user will upload, which I then want to display with edit capabilities on each row the user can change that have errors I flag before submitting this information to the database.

I think I have an idea on how to accomplish this, I will wind up with the cached object that I will display by by binding it to a dataset or datalist, with an eventhandler associated with each row that will access the corresponding cached information. What I don't understand is how to access a specific column in a specific row of that cached information. So, if I had a table with four rows, containing [column1] and [columns2], how would I ask for the value of [column2] in the thrid row?

Do I need to do anything special when I set it from the datasource, like so?

Session["MyDataSet"] = CreateDataSource();

If that's all I need to do, then what is the syntax for accessing a row in this manner?

thanks in advance, I'm in a crunch here and stuck on this, very appreciative of any help on this!!!



0
Comment
Question by:animated405
3 Comments
 
LVL 1

Expert Comment

by:confabber
ID: 11867914
0
 
LVL 2

Accepted Solution

by:
mahanatti earned 1000 total points
ID: 11869043
To access the dataset in the Session object,

DataSet ds = (DataSet)Session["MyDataSet"];
string ReqVal = ds.Tables[0].Rows[3]["Column2"].ToString(); //You can also use the Column index instead of column name

Hope this helps.

-Maha
0
 

Author Comment

by:animated405
ID: 11886395

So far so good, Maha...thank you very much.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
Six Sigma Control Plans
Screencast - Getting to Know the Pipeline

971 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