Home / Questions / 184192
Accepted
Aetos2501
Asked: 2020-07-27 09:27:19 +0800 CST 2020-07-27 09:27:19 +0800 CST

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

  • 772

Hello friend I have a problem with a table I have a field called names inside 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 doesn't work for me.

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

1 Answers

  1. Best Answer

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

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