I need to know how to reset radcombobox as filter in the radgrid.
I am able to use 3 radcomboboxes as filters in the grid. the problem is that when I finished filtering and I have AppendDataBoundItems="True" and using <Items><telerik:RadComboboxItem></Items>, that it will automatically give me 1 empty row. if I click this empty row, it won't go back to selectedvalue. it's like nothing or selectedindex = -1 and then rebind the grid with the rest of the filters. Or is there another way?
Please help.
Thank you.
<telerik:GridBoundColumn DataField="Dept" HeaderText="Department" SortExpression="Dept" |
UniqueName="Dept" > |
<FilterTemplate> |
<asp:TextBox runat="server" ID="TextBox1" style="display:none;"> |
</asp:TextBox> |
<telerik:RadComboBox ID="cboRadDept" DataSourceID="DeptSqlDS" DataTextField="Name" DataValueField="Name" |
AutoPostBack="True" AppendDataBoundItems="True" Height="100%" Width="170px" |
SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("Dept").CurrentFilterValue %>' |
runat="server" OnSelectedIndexChanged="cboRadDept_SelectedIndexChanged" Skin="WebBlue" > |
<Items> |
<telerik:RadComboBoxItem /> |
</Items> |
</telerik:RadComboBox> |
</FilterTemplate> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="From" HeaderText="Originator" SortExpression="From" |
UniqueName="From"> |
<FilterTemplate> |
<asp:TextBox runat="server" ID="TextBox2" style="display:none;"> |
</asp:TextBox> |
<telerik:RadComboBox ID="cboRadFrom" DataSourceID="FromSqlDS" DataTextField="UserName" DataValueField="UserName" |
AutoPostBack="True" AppendDataBoundItems="True" |
SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("From").CurrentFilterValue %>' |
runat="server" OnSelectedIndexChanged="cboRadFrom_SelectedIndexChanged" Skin="WebBlue"> |
<Items> |
<telerik:RadComboBoxItem /> |
</Items> |
</telerik:RadComboBox> |
</FilterTemplate> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Status" HeaderText="Status" SortExpression="Status" UniqueName="Status"> |
<FilterTemplate> |
<asp:TextBox runat="server" ID="TextBox3" style="display:none;"> |
</asp:TextBox> |
<telerik:RadComboBox ID="cboRadStatus" DataSourceID="StatusSqlDS" DataTextField="Status" DataValueField="Status" |
AutoPostBack="True" AppendDataBoundItems="True" Height="100%" Width="85px" |
SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("Status").CurrentFilterValue %>' |
runat="server" OnSelectedIndexChanged="cboRadStatus_SelectedIndexChanged" Skin="WebBlue"> |
<Items> |
<telerik:RadComboBoxItem /> |
</Items> |
</telerik:RadComboBox> |
</FilterTemplate> |
</telerik:GridBoundColumn> |
Protected Sub cboRadDept_SelectedIndexChanged(ByVal o As Object, ByVal e As RadComboBoxSelectedIndexChangedEventArgs) |
Dim filterItem As GridFilteringItem = DirectCast(RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)(0), GridFilteringItem) |
TryCast(filterItem("Dept").Controls(1), TextBox).Text = e.Value |
filterItem.FireCommandEvent("Filter", New Pair("EqualTo", "Dept")) |
End Sub |
Protected Sub cboRadFrom_SelectedIndexChanged(ByVal o As Object, ByVal e As RadComboBoxSelectedIndexChangedEventArgs) |
Dim filterItem As GridFilteringItem = DirectCast(RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)(0), GridFilteringItem) |
TryCast(filterItem("From").Controls(1), TextBox).Text = e.Value |
filterItem.FireCommandEvent("Filter", New Pair("EqualTo", "From")) |
End Sub |
Protected Sub cboRadStatus_SelectedIndexChanged(ByVal o As Object, ByVal e As RadComboBoxSelectedIndexChangedEventArgs) |
Dim filterItem As GridFilteringItem = DirectCast(RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)(0), GridFilteringItem) |
TryCast(filterItem("Status").Controls(1), TextBox).Text = e.Value |
filterItem.FireCommandEvent("Filter", New Pair("Contains", "Status")) |
End Sub |
Please help.
Thank you.