forum

Home / DeveloperSection / Forums / How to get records of specific columns of data table using c#.

Ask Question

How to get records of specific columns of data table using c#.

James Smith5198623-Jul-2011

Hi,

I have a small problem while making a program in c#. The problem is that I would like to access record of selected columns of data table in c#. Like suppose I have a data table which have four columns namely empId, empName, empAge and empCity . Now I would like to select record of only two columns of this data table. This is prity simple in sql query but how can I perform it into data table.

Help me!

Thanks.

c#c# 
Updated on 05-Apr-2019
James Smith

James Smith

Follow

Can you answer this question?

Answer

2 Answers

Anonymous User

Anonymous User

23-Jul-2011

Hi James,

You can easily select records of selected columns in DataTable. Check the code below.

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

If you want those columns with distinct records then pass first parameter true except false. You can also provide as many column as you want in the parameter.

Anonymous User

Anonymous User

23-Jul-2011

Hi james,

You can get information of selected columns in following way,

string[] selectedColumns =new[]{"ID","LastName"}; //It represent name of column for which you want to select records

DataTable tableWithOnlySelectedColumns = newDataView(table).ToTable(false, selectedColumns);

//Here table represent name of that DataTable which have all columns.

Thanks.

Please mark it as answer if your problem had been resolved.


Liked By