Delete column by his name from datatable using Linq

Help Something Else
, ,
1

Hi everyone,
I have a datatable with n columns.
How can I delete one using Linq, knowing its name?

Thank you :slight_smile:

2

@simone.trenta
LINQ Option

dt.Clone().Columns.Cast(Of DataColumn).Where(Function(c) c.ColumnName <> "YpurColumnToRemove").ToList().ForEach(Sub(c) newDt.Columns.Add(c.ColumnName, c.DataType))
dt.AsEnumerable().ToList().ForEach(Sub(row) newDt.Rows.Add(newDt.Columns.Cast(Of DataColumn).Select(Function(c) row(c.ColumnName)).ToArray()))

Option #2
Use activity Remove Data Column

1 Like
3

@simone.trenta

if an single column directly use remove data column..no need of linq

or if you dont want to use that activity or want to remove multiple and/or rearrange use

assign with dt = dt.DefaultView.ToTable(false,{"Col1","Col2"})here col1 etc are the column names you need and in the order you need

cheers