Solved

Chaching Dataset using session object

Posted on 2004-08-22
3
215 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AutoIncrement column based of FK 11 72
troubleshoot a python script 8 113
Getting Variable not defined error in Python 1 80
Java List 4 76
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

734 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