How can i get filtering my RadGrid with text? For Example in the slider 7 different Colour.
a b c d e f g
and in the default view table will show products all of this colours
when user draging slider from a to b
i want to showing products which coloured b c d e f g in my RadGrid
When it is all numbers in DB it is ok. No Problem but when i wanted filtering with text really confused.
Hope to hear you soon.
Regards
.
<
telerik:RadSlider runat="server" ID="RadSlider1" IsSelectionRangeEnabled="true"
MinimumValue="0" MaximumValue="300" SmallChange="1" SelectionStart="0" SelectionEnd="300"
OnClientValueChanging="OnClientValueChanging" OnValueChanged="RadSlider1_ValueChanged"
OnClientSlideStart="OnClientSlideStart" OnClientSlideEnd="OnClientSlideEnd" AutoPostBack="true"
ShowDecreaseHandle="false" ShowIncreaseHandle="false" />
SelectionStart: $
<asp:Label ID="lblSelectionStart" runat="server" Text="0"></asp:Label><br />
SelectionEnd: $
<asp:Label ID="lblSelectionEnd" runat="server" Text="300"></asp:Label>
Protected Sub RadSlider1_ValueChanged(ByVal sender As Object, ByVal e As EventArgs)
lblSelectionStart.Text = RadSlider1.SelectionStart.ToString()
lblSelectionEnd.Text = RadSlider1.SelectionEnd.ToString()
RadGrid1.Rebind()
End Sub
SelectCommand
="SELECT * FROM [Products] INNER JOIN [Suppliers] ON Products.SupplierID=Suppliers.SupplierID WHERE (UnitPrice > @MinimumPrice) AND (UnitPrice < @MaximumPrice) AND (UnitsInStock > @MinimumStock) AND (UnitsInStock < @MaximumStock) AND (CategoryID > @MinimumCategory) AND (CategoryID < @MaximumCategory)">
<asp:ControlParameter ControlID="RadSlider1" PropertyName="SelectionStart" Name="MinimumPrice" />