As per the price list i have to extract rows with price range between 10000 to 15000
Read the data into Datatable and use filter datatatable where you can set less than or greater than the values and filter the rows
hi thanks for the reply
but ineed to filter between 10000 - 15000 not like above or below
This is how you give it
Click the plus on the right and new line would be added. You can give multiple conditions
But this one getting the value below 10000
as u can see in 3rd row “9299”
Did you give OR condition or And?
Can you show what you did
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