Filter Datatable - Not like filter

Hello Everyone,

Can anyone please help me with the syntax for “Like” operator in filtering a datatable

Couldn’t find in this forum as well. Moreover when I try it returns as a datarow but I want to have a datatable. Even if I try to declare the assign “To” variable as “DataTable”, I am getting an error message that Datarow cannot be converted to DataTable


1 Like

Hi @Selvasathappan,

use below query

DataTable=DataTable.Select("ColumnName like '%Arivu%'").CopyToDataTable()

More related to datatable information


1 Like

Thanks dude. You are awesome.

@arivu96, Any thoughts on below issue?

@arivu96 - Can you please help me with this?

@arivu96 - Can you please help e with this?