This is a migrated thread and some comments may be shown as answers.

Is there any way to programatically clear all filter values on a rad grid using vb.net?

7 Answers 757 Views

Grid

This is a migrated thread and some comments may be shown as answers.

7 Answers, 1 is accepted

answered on 18 Mar 2009, 05:00 PM

This seems to prevent the value from being used as a filter, which is good, but more specifically I'm looking to clear the actual filter text box for all filters and this code doesn't do that. I tried the below code but it doesn't clear the grid's filter textboxes either. Any suggestions?

Private

Sub clearRgHFilters()

For Each item As GridItem In rgH.Items

If TypeOf item Is GridFilteringItem Then

Dim filteringItem As GridFilteringItem = CType(item, GridFilteringItem)

Dim merchbox As TextBox = CType(filteringItem("MERCHANT_NAME").Controls(0), TextBox)

merchbox.Text =

Dim transcomp As TextBox = CType(filteringItem("TRANS_COMP").Controls(0), TextBox)

transcomp.Text =

Dim cardholder As TextBox = CType(filteringItem("SORTNAME").Controls(0), TextBox)

cardholder.Text =

Dim job As TextBox = CType(filteringItem("JOBNUM").Controls(0), TextBox)

job.Text =

Dim phase As TextBox = CType(filteringItem("PHASE").Controls(0), TextBox)

phase.Text =

Dim cat As TextBox = CType(filteringItem("CATEGORY").Controls(0), TextBox)

cat.Text =

Dim postdate As TextBox = CType(filteringItem("CMIC_POST_DATE").Controls(0), TextBox)

postdate.Text =

Dim transnum As TextBox = CType(filteringItem("SOURCE_TXN_NUMBER").Controls(0), TextBox)

transnum.Text =

Exit For

End If

Accepted

answered on 30 Jul 2009, 07:06 PM

I am using that exact code:

Protected

Sub clrFilters_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)

For Each column As GridColumn In radGrid1.MasterTableView.Columns

column.CurrentFilterFunction = GridKnownFunction.NoFilter

column.CurrentFilterValue =

String.Empty

radGrid1.MasterTableView.FilterExpression =

String.Empty

radGrid1.MasterTableView.FilterExpression =

Nothing

radGrid1.MasterTableView.Rebind()

End Sub

and when the grid rebinds, i get an empty first row
The size of the dataset did not change, but the grid is adding a blank row at the top. If I filter again, it is gone.
If I clear the filters by clearing the filter text in each column, I do not get the blank row, it only happens when clicking the "Clear Filters" button.

Any ideas?