Delete rows in linq

[Boopathi (Boopathi Manogar)]

Hi Team,

I need to delete row in linq if name columns contains any comma,

Aware that it can be achieved using filter datatable activity but wish to know how to do in linq query

Thanks,
Ula

[supermanPunch (Arpan)]

@Boopathi Can you try this Query Using Assign :
Let’s say you have the Datatable as DT, Then ,

DT = DT.AsEnumerable().Where(Function(row) Not(row(“Name”).ToString.Trim.Contains(“,”))).CopyToDataTable

[Pradeep_Shiv]

DataTableVar = DataTableVar.AsEnumerable.Where(Function(row) Not row(“Name”).ToString.Contains(“keyword”) ).CopyToDataTable