Exclude a list of Strings in a table in C #?

Question

Exclude a list of Strings in a table in C #?

Navigation

#1 by (3 votes)

4

Hello friend I have a problem with a table I have a field called names within this table and I have a list of names which I want to exclude from the table based on the name field. I have the following but it does not work for me.

var DataRows = Tabla.AsEnumerable().Where(item => item["Nombre"].ToString().Distinct().Where(nombre=> ListaNombres.ForEach()))

c# linq

asked by Aetos2501 26.07.2018 в 19:27

source

1 answer

How to remove a specific element from an array? Find out if a div is full

score 3 · Accepted Answer

You should check if the string list exists in your item item, with Any() , in this case we add a NOT , which would return that if the item exists it does not add it

   var DataRows = Tabla.AsEnumerable().Where(
                    item => !ListaNombres.Any(n => n == item["Nombre"].ToString()));