How to set range to filter rows

[jai_kumar2 (jai kumar)]

Hi

As per the price list i have to extract rows with price range between 10000 to 15000

Thank you

[Anil_G (Anil Gorthi)]

Hi @jai_kumar2

Read the data into Datatable and use filter datatatable where you can set less than or greater than the values and filter the rows

cheers

[jai_kumar2 (jai kumar)]

hi thanks for the reply

but ineed to filter between 10000 - 15000 not like above or below

[jai_kumar2 (jai kumar)]

i Tried this way but not working

[Anil_G (Anil Gorthi)]

@jai_kumar2

This is how you give it

Click the plus on the right and new line would be added. You can give multiple conditions

cheers

[jai_kumar2 (jai kumar)]

But this one getting the value below 10000

as u can see in 3rd row “9299”

[Anil_G (Anil Gorthi)]

@jai_kumar2

Did you give OR condition or And?

Can you show what you did

cheers

[jai_kumar2 (jai kumar)]

And Condition

[Anil_G (Anil Gorthi)]

@jai_kumar2

Input

Condition

Output

Is the datatype of the column string or Double?

if string then either change the datattype or use linq

dt.AsEnumerable.Where(function(x) CDBL(x("ColumnName").ToString.Trim)>10000 and CDBL(x("ColumnName").ToString.Trim)<15000).CopyToDatatable

cheers

cheers