How to remove more DataTable Columns using C#.Net?

Question

I have One DataTable may have more Columns. But "NetAmount", "TotalAmount", "Destination" are the DataTable Columns which always present in the DataTable.

Here I want to Remove the three Columns such as "NetAmount", "TotalAmount" and "Destination" from the DataTable and to take the other column values in the DataTable.

I tried like the below and get the Desired Output.

  dtAttribute.Columns.Remove("NetAmount"); //dtAttribute is the Main DataTable
  dtAttribute.Columns.Remove("TotalAmount");
  dtAttribute.Columns.Remove("Destination");
  DataTable dtItem = dtAttribute.Copy();

But it looks like very childish and lengthy. Is there any other method to do? Please give suggestions.

Are you sure this works? According to the documentation DataColumnCollection.Remove is a void method, i.e., it should not return a value. Please show us your real code instead of something that looks like your code. — Heinzi
– Heinzi, Commented Jul 21, 2011 at 12:17
Are you sure you took that sample from the code that compiled ok? If I am not wrong, the Remove method is of type void. Also calling Remove 3 times is not lengthy / childish if that's the only method provided by the API. — Vijay Gill
– Vijay Gill, Commented Jul 21, 2011 at 12:18
@Heinzi & Vijay: hi sorry for both. I just typed without actually gothrough my code. Now I edited my Question. Please have a look at it. — thevan
– thevan, Commented Jul 21, 2011 at 12:23
@thevan: Why do you make a copy after removing the columns? — Heinzi
– Heinzi, Commented Jul 21, 2011 at 12:25

Heinzi · Accepted Answer · 2011-07-21 12:25:55Z

7

There's nothing wrong with your code (except that you are copying the table after removing the columns -- are you sure that this is what you want?).

If you want something more abstract (instead of repeating the same line again and again), you might consider removing the columns in a loop:

var dtItem = dtAttribute.Copy();    // if you want to keep a copy of the original table

var toRemove = new string[] {"NetAmount", "TotalAmount", "Destination"};
foreach (col in toRemove)
    dtItem.Columns.Remove(col);

edited Jul 21, 2011 at 12:25

answered Jul 21, 2011 at 12:19

Heinzi

173k61 gold badges386 silver badges554 bronze badges

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

6 Comments

SearchForKnowledge Over a year ago

What if I wanted to remove let's say column 0 to 9?

Heinzi Over a year ago

@SearchForKnowledge: Well, DataTable.Columns returns a value of type DataColumnCollection, and DataColumnCollection has a method called RemoveAt. Does that help you answer your question on your own?

SearchForKnowledge Over a year ago

@Heinzi I tried that so let's say I have four columns, 0, 1, 2, 3. Every time I iterate to use RemoveAt() it removes every other column but thank you :) +1

Heinzi Over a year ago

@SearchForKnowledge: As soon as you remove row 0, the (old) rows 1, 2, 3 become (new) rows 0, 1, 2. There are two obvious ways to fix this. Can you guess what they are?

Heinzi Over a year ago

@SearchForKnowledge: Exactly! The other option is to remove 3, 2, 1, 0 instead of 0, 1, 2, 3.

|

Steve Wellens · Accepted Answer · 2011-07-21 12:34:43Z

0

Instead of removing the columns, how about not putting them in the DataTable in the first place?

answered Jul 21, 2011 at 12:34

Steve Wellens

20.6k2 gold badges31 silver badges70 bronze badges

3 Comments

thevan Over a year ago

I am getting the DataTable from the BackEnd. And I also need those columns for one another purpose.

SearchForKnowledge Over a year ago

I have a DataSet, how can I add the first half of it into a DataTable.

Kiquenet Over a year ago

@SteveWellens I use DataTable with ExcelPackage (EPPlus)

Ali Borjian · Accepted Answer · 2022-06-06 04:49:47Z

0

First select columns which you want to remove, then remove them

List<string> toRemove = dt.Columns.Cast<DataColumn>().Where(c => c.ColumnName.StartsWith("ExtraColumn")).Select(c => c.ColumnName).ToList();
foreach (var col in toRemove) dt.Columns.Remove(col);

answered Jun 6, 2022 at 4:49

Ali Borjian

1,12613 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to remove more DataTable Columns using C#.Net?

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related