Linq Query(1)

I have four columns in a excel with the values, I want to filter the excel with known 2 values of a column, where one value present in one column and other value is on other column and check whether they present in the excel or not, if it is present then I want filter the whole matched row and put it to the datatable , write it to the new excel ?

yah
hope this expression would help you
yourdatatablename.Select("[yourcolumnname1] = ‘value’ AND [yourcolumnname2] = ‘value’ ").copytodatatable()

Cheers @Manish540

coming some error saying that value is not present.

I gave the proper column names and values.

can i see your expression been used may be with a screenshot
@Manish540

dataTable.Select("[Item Number] = ‘10101404’ AND [Business Unit] = ‘370220’ ").copytodatatable()
Data.xlsx (9.1 KB)

1 Like

above are the excel sheet and the code that I used.

1 Like

here you go its working fine
hope its resolved
select.zip (16.2 KB)

Cheers @Manish540

1 Like

Thank You, It’s Working.:slightly_smiling_face:

Cheers @Manish540

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.