How to filter datatable based on range?

[anon54733438]

Hi guys,

I am having problem to filter data table based on 2 values.

For example, i am trying to filter a data table with values between 89.9 to 110.

I already trying to use filter data table activity but it returns no row.

Anyone have any idea to solve this one?

[Yoichi]

Hi,

If there is only numeric data in the target column, the following will work.

filteredDt = dt.AsEnumerable.Where(Function(r) Double.Parse(r("Columnname").ToString)>89.9 AndAlso Double.Parse(r("Columnname").ToString)<110).CopyToDataTable()

If there is non-numeric data including blank, we need to modify the above expression.

Regards,

[anon54733438]

Thanks man for the reply.

I receive this error:

The source contains no data rows.

Any thought to fix this error?

[Yoichi]

Hi,

The source contains no data rows.

This mean there is no row which matches the condition.
To avoid this error, can you try as the following?

arrayDataRow =  dt.AsEnumerable.Where(Function(r) Double.Parse(r("Columnname").ToString)>89.9 AndAlso Double.Parse(r("Columnname").ToString)<110).ToArray()

Hope this helps you.

Regards,

[anon54733438]

Thanks bro.

It works like a charm.

Have a nice day.