The Select method to filter the Datatable is not working. It is not filtering based on the provided condition. Instead it is giving all the rows. Please find attached the screen shot.
Please use ‘Trim’ function for both columns.
dt_WIs.Select(“Type=‘WI5’ AND Status = ‘Open’”)
this can be used to populate a System.DataRow object which will have all the rows you need.
There is nothing wrong with the expression.
I guess you are exporting the wrong data table.
Make sure you are exporting
out_FilteredDataTable to the Excel.
Great! That resolves the issue. it was my mistake wrongly exporting the data table. Thank you so much.
Can you please mark my previous post as solution. Thank you