Solved

Chaching Dataset using session object

Posted on 2004-08-22
3
216 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 1

Expert Comment

by:confabber
ID: 11867914
0
 
LVL 2

Accepted Solution

by:
mahanatti earned 250 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Part One of the two-part Q&A series with MalwareTech.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

615 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