How to store one column data from datatable to a view state

Question

4.33/5 (2 votes)

See more:

Hi,
I have multiple column in the datatable.i want second coulmn value and store into viewstate or hidden filed. how to store one column data in a view state.

my code is
EX--

C#

 DataTable _dtblanck = GetLatestDataFromGrid();

_dtblanck = obj.madeAddTable(_dtblanck, Session["LoginName"].ToString());
 ViewState["dourceofgoods"] = _dtblanck;

Here , i my code datatable is saving with all columns. i need to save only one column data in view state.

suppose this three couln is comming from datatable. i need to store only employeename column data into viewstate or hidden filed. how to store one column data.

Emplid Employeename age

1 Raj 25
2 ram 35
3 Rasmi 20

Posted 14-Jan-14 20:05pm

kamalsekhar

Updated 14-Jan-14 21:05pm

v4

Add a Solution

Comments

Ankur^\m/ 15-Jan-14 2:30am

A column may have many rows. Do you want a particular row's value or all rows in the column?

kamalsekhar 15-Jan-14 3:06am

i want all row data from that particular column

Ankur^\m/ 16-Jan-14 1:04am

You will store it in comma separated values or something like that if you are storing it in a hidden field as you can only save string in it. For Viewstate you can create a string array and store it. But make sure whatever you are storing isn't very large as it will impact the performance of your site.

Prasaad SJ 15-Jan-14 4:16am

May I know What r you doing with DataTable.. ? You r displaying the Table in Grid View.. Or using only for the logical opertions..

2 solutions

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)

Karthik_Mahalingam · Answer 1 · 2014-01-14T20:07:00

Solution 1

try like this..

C#

HiddenFieldControlName.Value=  dt.Rows[0]["columnName"].ToString();

Posted 14-Jan-14 20:07pm

Karthik_Mahalingam

Comments

kamalsekhar 15-Jan-14 2:33am

Hi Karthik,
I need to store all data which are comming from datatable of particular coulmn . not a single row data.

Karthik_Mahalingam 15-Jan-14 2:50am

then you can store in an array

Karthik_Mahalingam 15-Jan-14 2:51am

ViewState["somekey"]= dt.Rows.OfType<datarow>().Select(K=> K["columnName"].ToString()).ToArray();
try this..

kamalsekhar 15-Jan-14 3:04am

DataTable _dtblanck = GetLatestDataFromGrid();

_dtblanck = obj.MadeAddTable(_dtblanck, Session["LoginName"].ToString());
ViewState["dourceofgoods"] = _dtblanck.Rows.OfType().Select(K => K["mio_source"].ToString()).ToArray();

Here error is giving last line

Karthik_Mahalingam 15-Jan-14 3:15am

whar error ?
make sure the column name is "mio_source"

kamalsekhar 15-Jan-14 3:58am

'System.Data.DataRowCollection' does not contain a definition for 'OfType' and no extension method 'OfType' accepting a first argument of type 'System.Data.DataRowCollection' could be found (are you missing a using directive or an assembly reference?)

This is the error i m geeting

Karthik_Mahalingam 15-Jan-14 4:02am

ok..
add this..

using System.Linq;

kamalsekhar 15-Jan-14 4:15am

Already i have added this namespace. still error

Karthik_Mahalingam 15-Jan-14 4:57am

run time error or compile error ??

kamalsekhar 15-Jan-14 7:34am

compile time error

Karthik_Mahalingam 15-Jan-14 7:42am

are you using System.Data.DataTable ??
or some other ??

kamalsekhar 15-Jan-14 8:29am

using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Linq;

these are namespace i m using

Karthik_Mahalingam 15-Jan-14 8:37am

Try like this..

List<string> lst = new List<string>();
for (int i = 0; i < dt.Rows.Count; i++)
lst.Add(dt.Rows[i]["columnName"].ToString());

ViewState["somekey"] = lst.ToArray();

kamalsekhar 16-Jan-14 4:46am

HiI m using viewstate for storing the datatable value.
ViewState["GoodsDetails"] == dt.Rows[0]["columnName"].ToString();

I want to pass this value to another page. but its not working. null only comming
lblmadeinomanCateg.Text = (string)ViewState["GoodsDetails"]; --Here null is comming data is not comming

Karthik_Mahalingam 16-Jan-14 4:55am

if you are using the value in next page , viewstate wont work..
you shld use session..
replace viewstate by session.. it will work...

Hammad · Answer 2 · 2014-01-14T20:44:00

Solution 2

Try this

C#

string[] arrayVariable= _dtblanck.AsEnumerable().Select(s => s.Field<string>("LoginName")).ToArray<string>();

Now you have all values of your column in an array do whatever you want to do with it.

Posted 14-Jan-14 20:44pm

Hammad

Updated 14-Jan-14 21:15pm

v2

Comments

kamalsekhar 15-Jan-14 3:03am

How to store this string array value into a hidden filed or view state

Hammad 15-Jan-14 3:12am

Probably a few methods would work.

1) Serialize the string[] in JSON

This would be fairly easy in .NET using the JavaScriptSerializer class, and avoid issues with delimiter characters. Something like:

string json = new JavaScriptSerializer().Serialize(arrayVariable);

now store it in hidden field like
HiddenFieldControlName.Value=json;

2) Come up with a delimiter that never appears in the strings

Delimit each string with a character such as ||| that will never appear in the string. You can use String.Join() to build this string. Something like:

string str = String.Join("|||", arrayVariable);
HiddenFieldControlName.Value=str;

And then rebuild it like:

string str=HiddenFieldControlName.Value.ToString();
myValues = str.Split(new string[] { "|||" }, StringSplitOptions.RemoveEmptyEntries);