I want to filter a data table and want to filter on the basis of a column. The bot should keep the rows if the column value is YES, Yes or yes. How can I use OR condition here?
Use this below linq query, @Pankit
DataTable = InputDt.AsEnumerable.Where(Function(row) row(“YourColumnName”).ToString.Trim.ToLower.Equals(“yes”)).CopyToDataTable()
Hope this may help you 