Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Chaching Dataset using session object


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
animated405
Asked:
animated405
1 Solution
 
confabberCommented:
0
 
mahanattiCommented:
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
 
animated405Author Commented:

So far so good, Maha...thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now