how to apply filter on same column for different values in c#
<p>I am applying filter logic on my code where i am filtering my resultset for different values. Situation is i want to filter one column say 'ItemPrice' for 'itemno' e.g. 'itemprice' between '10' to '100' for 'itemno' 1, after this filter i want to filter with 'itemprice' between '23' to '136' for 'itemno' 3 with maintaining first filter result also, means now my condition is for both e.g." 'itemprice' between '10' to '100' for 'itemno' 1 and 'itemprice' between '23' to '136' for 'itemno' 3 ". Upto six 'itemno' i can filter the price for any values like " Item:1 price: 7-40, Item:2 price: 14-400, Item:3 price: 300-2301, Item:4 price: 30-35, Item:5 price: 45-230, Item:1 price: 121-356 ".</p>

<p>So any combination can occur , for this i am trying to save main resultset in session and viewstate and each time i am sending all filter parameters to method for filtering , but it is not working well.
this all fitering works in C# on Dataviews not in sql</p>

<p>can anybody suggest me the best solution to tackle this situation.</p>

<p>Thanks in advance.</p>
