How do we find of two column values in another column using LINQ C#

Question

I have 3 columns and it contains some values.

I want to find of two column (COL1 and COL2) values in another column (COL3)

i.e. COL1 and COL2 values should check in COL3.

If any values found in in COL3, it should return true, else false.

     DataTable tblData = new DataTable();
     tblData.Columns.Add("COL1", typeof(string));
     tblData.Columns.Add("COL2", typeof(string));
     tblData.Columns.Add("COL3", typeof(string));
     tblData.Rows.Add("AM", "120", "AM-120");

Note : Here COL3 value may be either "AM-120" or "AM 120"

Answer 1

Try something like this:

bool result = tblData.AsEnumerable( ).Any( r =>
 {
 string v1 = r.Field<string>( "COL1" );
 string v2 = r.Field<string>( "COL2" );
 string v3 = r.Field<string>( "COL3" );

 return v3.Contains( v1 ) || v3.Contains( v2 );
 } );

Use "&&" instead of "||" if you need both values. It is also possible to perform case-insensitive comparison.