how to get column values by specific column name from datatable in c#

Question

0.00/5 (No votes)

See more:

C#

how to get column values by specific column name from datatable in c#

please help..

Posted 4-Sep-13 20:31pm

Apali

Add a Solution

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)

Mohan Gopi · Accepted Answer · 2013-09-04T20:42:00

Solution 2

Hi Apali, try this;

C#

DataView dv = new DataView(Your DataTable);

  DataTable dt = dv.ToTable(true, "Your Specific Column Name");

//this dt contains only selected column values.

I hope this will help you.

Thank's
Mohan G

Posted 4-Sep-13 20:42pm

Mohan Gopi

Comments

Apali 5-Sep-13 2:51am

thnx a lot...i got by this code...

Apali 5-Sep-13 2:56am

DataView dv = new DataView(dtDataTable);
DataTable dt = dv.ToTable(true, "PONUMBER");

here i got the PONUMBER column values in dt.

how i will compare 1st index and second index value of dt...

Mohan Gopi 5-Sep-13 2:58am

you have only two rows on that dt or more rows

Apali 5-Sep-13 3:01am

above 100 rows are there..i have to add same values

Mohan Gopi 5-Sep-13 3:04am

you want to compare the values like;
row1=row2;
row3=row4;

are what? give some clear explanation.

Apali 5-Sep-13 3:06am

yes i want to compare 1st row with 2nd row
i used like this but its showing error
for (int k = 0; k < arrCostingSheetColumnList.Count; k++)
{
if (dt[k]==dt[k + 1])
{

}
}

Mohan Gopi 5-Sep-13 3:10am

try this;

int r = 0;
int r2 = 1;
foreach (DataRow dr in dt.Rows)
{
dr[r] = dr[r2];
r = r + 2;
r2 = r2 + 2;
}
this will solve your problem.

Apali 5-Sep-13 3:24am

hi by using below code i am getting distict column values...repeated values are not coming..but i want all the values of POVALUE column. pls help

DataView dv = new DataView(dtDataTable);
DataTable dt = dv.ToTable(true, "PONUMBER");

Mohan Gopi 5-Sep-13 3:35am

try this;
DataTable dt = dv.ToTable(false, "PONUMBER");

Apali 5-Sep-13 5:51am

thnx a lot..i am getting now

Srilekha Bolamoni 15-Nov-18 0:43am

my datatable consists of 60 columns and 21 rows but from that I want to read only 6 columns. so can I give 6 column names at a time and get the data.

Thomas ktg · Accepted Answer · 2013-09-04T20:34:00

Solution 1

Hi
Here is the link to get the answer for your question

http://stackoverflow.com/questions/2916583/how-to-get-a-specific-column-value-from-a-datatable[^]

Posted 4-Sep-13 20:34pm

Thomas ktg

Comments

Apali 5-Sep-13 2:42am

thnx but i want the code in c#,can you please help

Thomas ktg 5-Sep-13 2:53am

give me the code you tried.

Apali 5-Sep-13 2:57am

ya i got that one but see the below code
DataView dv = new DataView(dtDataTable);
DataTable dt = dv.ToTable(true, "PONUMBER");
here i got the PONUMBER column values in dt. how i will compare 1st index and second index value of dt...

Thomas ktg 5-Sep-13 2:56am

DataTable dtSelectedColumns = dtOriginal.DefaultView.ToTable(true, "Column1", "Column2");

Apali 5-Sep-13 3:33am

no still same problem by using this code also..i want same value in columns so i can check it is equal or not...but by this i m getting distinct column values.