Filter datatable for Dynamic rows value

[Prateek_Pathak]

Hello community,
i want to keep rows which i will be providing through Datatable but this table contains some part of rows
For Example:
dt1:

dt2:

Output:

Note:dt1 will have dynamic rows, i want to keep rows of dt2 which contains the dt1 rows values in Dt2

[lrtetala (Lakshman Reddy)]

Hi @Prateek_Pathak

Try this

dt2.AsEnumerable().Where(Function(row) dt1.AsEnumerable().Any(Function(r) row("Brand_ID").ToString.Contains(r("Brand_ID").ToString))).CopyToDataTable()

Input:

DT1

DT2

Output:

Regards,

[ppr (Peter Preuss)]

One of many options

Assign Activity
dtResult =

(From d in dt2.AsEnumerable
Let mv = d("Brand_ID").toString
Where dt1.AsEnumerable.Any(Function (x) mv.Contains(x("Brand_ID").toString.Trim) )
Select r=d).CopyToDataTable

And also

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.AsE…

[Prateek_Pathak]

thanks for the solution its woking fine.