Retriving and storing dataset to view state

Question

1.00/5 (1 vote)

See more:

I have one table called "Operator"and I want to retrieve a single column called "OperatorCode" and store it into a View state and later I want to retrieve single single values from View State What should i do..Please suggest

What I have tried:

ViewState["OprCode"] = Convert.ToString(dsbindoperator.Tables[0].Rows[0]["Opr_Code"]);

DataSet ds=(DataSet)ViewState["OprCode"];

But This is giving me error

Posted 3-Oct-16 1:36am

Member 12749751

Updated 3-Oct-16 3:08am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2016-10-03T03:08:00

Solution 1

ViewState["OprCode"] is a string that contains the value of Opr_Code, however you are trying to retrieve it as a DataSet

C#

string code = (string)ViewState["OprCode"];

or

C#

string code = ViewState["OprCode"] as string;

Posted 3-Oct-16 3:08am

F-ES Sitecore

Comments

Member 12749751 3-Oct-16 9:29am

Actually I have to retrieve single column for all the rows and I want to store all the values inside a view state and after wards one by one i have to fetch the values from view state

F-ES Sitecore 3-Oct-16 9:38am

You'll need to use something that can be persisted in the ViewState like an array of strings (string[]). Build a string array of all the values by looping through the dataset a row at a time, and store that array in the ViewState.