(C#) How can I extract Datatable when the value of a specific column belongs to the value in the list?

Question

I want to extract only rows that fit certain conditions in the original datatable with C#.
Extracting rows that match one value were easy to find on the Internet and wrote the following code.

dt_thk = dt_raw.AsEnumerable()  
                 .Where(Row => Row.Field<string>("A") == "B")  
                 .CopyToDataTable();  

But I want to extract rows that are the values of "B", "C", "D", "E", "F". How do I make the code in this case? Thank you for any help.

Answer 1

Hi,@jun1.lee . You could try the code below to see if it helps you. For more information, you can refer the solution here.

var res = from row in dt_raw.AsEnumerable()  
where (row.Field<string>("A") == "B" ||  
row.Field<string>("A") == "C" ||  
row.Field<string>("A") == "D"||  
row.Field<string>("A") == "E"||  
row.Field<string>("A") == "F")  
select row;  

----------------------------------------------------------------------------

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

        //you can assign conditions flexibly  
        List<string> listTemp = new List<string> { };  
        listTemp.Add( "B" );  
        listTemp.Add( "C" );  
        listTemp.Add( "D" );  
        listTemp.Add( "E" );  
        listTemp.Add( "F" );  

        dt_thk = dt_raw.AsEnumerable( )  
              .Where( Row => listTemp.Contains(Row.Field<string>( "A" )))  
              .CopyToDataTable( );