How to select a particular column from datatable

Question

1.44/5 (2 votes)

See more:

in a datatable there are number of columns ,out of which i want to select a particular coulmn.

What I have tried:

i have tried number of ways ,by searching on google

Posted 26-Jul-16 1:17am

manish-gusain8909

Updated 26-Jul-16 1:36am

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)

OriginalGriff · Answer 1 · 2016-07-26T01:34:00

You can use the Columns collection:

C#

using (SqlConnection con = new SqlConnection(strConnect))
    {
    DataTable dt = new DataTable();
    using (SqlDataAdapter da = new SqlDataAdapter("SELECT TOP 20 Title FROM Videos ORDER BY Title ASC", con))
        {
        da.Fill(dt);
        }
    DataColumn dc = dt.Columns[0];
    }

But that won't give you access to the actual values in each column of the table.
For that, you need to iterate the Rows collection:

C#

foreach (DataRow row in dt.Rows)
    {
    Console.WriteLine(row[0]);
    }

Afzaal Ahmad Zeeshan · Answer 2 · 2016-07-26T01:36:00

You can access the column from the rows of the DataTable. Just like any data table, you first access the rows and then you access their columns.

C#

var table = GetYourDataTable();

foreach (var row in table) {
   var column = row["ColumnName"];

   // Use the column
}

The table would provide access to rows and you can then access each column individually using their name or the index they are at. This MSDN guide is not about getting the columns but it gives you an idea of how you can get the columns (for getter and setter actions). Adding Data to a DataTable[^].

How to select a particular column from datatable

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0