title: Binding Datasets to Parameter
body: <p>Please can someone tell me how to bind a dataset to parameters (@Productcategory and @PriceRange) that uses this filtering condition or is there another way to have written this filter. </p>
  
  <p>Thanks Emma</p>
  
  <pre><code>WHERE ( ( ProductCategory.Name = @ProductCategory OR
            ( @ProductCategory = 'All Bike Related' AND 
              ProductCategory.Name IN ('Bikes', 'Components')) OR
            (@ProductCategory ='All')
          ) AND
          ( (@PriceRange = 'Less than 50' AND ListPrice &lt; 50) OR
            (@PriceRange ='50 to 99' AND ListPrice BETWEEN 50 AND 99) OR
            (@PriceRange ='100 to 499' AND ListPrice BETWEEN 100 AND 499) OR
            (@PriceRange ='500 and higher 'AND ListPrice &gt;=500) OR
            (@PriceRange = 'All')
          )
        )
  </code></pre>