How To select Specific Column From DataTable in C#?

Question

I have a dataTable with 4 columns , I want to select one column without foreach or any other expensive loop and my result must be a new data table with one column ,How can I do this;

DataTable leaveTypesPerPersonnel = LeaveGroup.GetLeaveTypesPerPersonnels(dtPersonnel.row);

leaveTypesPerPersonnel has this columns :

[ID,Guid,LeaveTypeID,Code]

I want Filter leaveTypesPerPersonnel wihtout foreach and get new datatable with just Column [ID]

NOTE: Output must be a Datatable With one column.

Possible duplicate of Remove columns from DataTable in C#

Hogan
– Hogan

2019-01-21 16:38:45 +00:00
Commented Jan 21, 2019 at 16:38 — Hogan
– Hogan, Commented Jan 21, 2019 at 16:38

Hogan · Accepted Answer · 2019-01-21 16:47:50Z

3

 leaveTypesPerPersonnel.Columns.Remove("Guid");
 leaveTypesPerPersonnel.Columns.Remove("LeaveTypeID");
 leaveTypesPerPersonnel.Columns.Remove("Code");

or

 DataTable dt= new DataView(leaveTypesPerPersonnel).ToTable(false,"ID");

edited Jan 21, 2019 at 16:47

answered Jan 21, 2019 at 16:39

Hogan

70.7k10 gold badges83 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Noreke · Accepted Answer · 2019-01-21 16:51:43Z

0

You should be able to run a quick LINQ statement against the data table.

var results = (from item in leaveTypesPerPersonnel
               select item.ID);

This will give you an IEnumerable if I remember correctly. It's not a DataTable, but might provide a solution to your problem as well.

answered Jan 21, 2019 at 16:51

Martin Noreke

4,1661 gold badge24 silver badges36 bronze badges

3 Comments

Hogan Over a year ago

This is a loop. While he said ForEach in the question, I believe he meant any loop.

Martin Noreke Over a year ago

I believe the intent of the poster is not to have to do a for each loop of his data set to build a new structure, not that methods that utilize a loop internally cannot be utilized.

Hogan Over a year ago

That is an interesting belief, the poster says "foreach or any other expensive loop". Sound like he or she does not want a loop.

Alen.Toma · Accepted Answer · 2019-01-21 18:19:34Z

-1

Here is a try on how to search and convert the result to DataTable

 var dataTable = leaveTypesPerPersonnel.Rows.Cast<DataRow>().ToList().Where(x=> x["ID"] == 21).CopyToDataTable().DefaultView.ToTable(false, "ID");

Or

 var dataTable = leaveTypesPerPersonnel.Select("ID = 21").CopyToDataTable().DefaultView.ToTable(false, "ID");

Or

   var dataTable = leaveTypesPerPersonnel.Rows.Cast<DataRow>().ToList().CopyToDataTable().DefaultView.ToTable(false, "ID");

edited Jan 21, 2019 at 18:19

answered Jan 21, 2019 at 17:13

Alen.Toma

4,8782 gold badges19 silver badges37 bronze badges

4 Comments

Hogan Over a year ago

This is a loop. While he said ForEach in the question, I believe he meant any loop.

Hogan Over a year ago

Also this is only returning one row. The poster is clearly asking for a table not a row.

Alen.Toma Over a year ago

my friend CopyToDataTable return a DataTable and ToTable also return a DataTable. its upp to him to specify which rows to return. he can have all rows in the DataTable

Alen.Toma Over a year ago

hahaha no i just added a third Or where you can have all rows without filter. i did not change anything.

Collectives™ on Stack Overflow

How To select Specific Column From DataTable in C#?

3 Answers 3

Comments

3 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related