GridFilterBar error

[Jose Luis Melo]

Hi,

I have a GridFilterBar inside a GridDataBoundGrid.

If I select a value from the GridFilterBar combos, the affected rows are shown.

Then I update the grid''s DataSource with the same datatable, but with new rows.
I save the RowFilter string and then put it again, so I can keep the selected information.

Then if I select "none" from the GridFilterBar combos, the new rows are missing !!! But their values are inside the GridFilterBar combos, so I can filter them, and If I select one of those rows, the row is shown. But If I select "none", the rows are not shown !!!

Do you have any idea why this happens, or to solve the problem ???

(using 1.6.1.8)
Thanks for your time,
Jose Melo

[Administrator]

After adding your new rows to the DataTable, are you calling DataTable.AcceptChanges? If not, you might try calling AcceptChanges on your Datatable to see if that avoids this probloem.

[Jose Luis Melo]

The AcceptChanges() didn''t solve the problem.

I made some experiences and realised that the rows realy are inside the DataTable, so there is no problem with the data being or not in the DataTable (i think).

The problem is that: the ''none'' option is selected, but it seems it is not being executed (this only happens when ''none'' is the first option I select, after the grid being refreshed).

By the way, when I select ''none'' the DataSet.Tables(1).DefaultView.RowFilter value is not changed, and the value that was selected (filtered), keeps being filtered.

If I select other value, the filter works perfectly. And then the ''none'' option work ok again.

Is there any action I might be executing that deletes the ''none'' action ?

Thanks again,
Jose Melo

[Administrator]

When you are resetting the filter when the selection is "none", if you explicitly set

DataSet.Tables(1).DefaultView.RowFilter = ""

does this make things work?

[Jose Luis Melo]

Yes, perfectly...

>When you are resetting the filter when the selection is "none", if you explicitly set
>

>DataSet.Tables(1).DefaultView.RowFilter = ""
>

>
>does this make things work?

[Jose Luis Melo]

explicity means that I insert a break point in the grid''s click event and execute the RowFilter="". This action reset the grid''s filter.

But the problem continue happening. Or there is any event I can execute this line (RowFilter="") ?

Thanks,
Jose Melo

[Administrator]

"I save the RowFilter string and then put it again,"

Where you are currently ''putting it again'', first set DataSet.Tables(1).DefaultView.RowFilter = "", and then ''put it again''.

[Jose Luis Melo]

Dim index as integer = grid.CurrentCell.RowIndex
'' record the filter to a string
Dim strFilter as string = dataset.Tables(1).DefaultView.RowFilter()
Dim strSort as string = dataset.Tables(1).DefaultView.Sort()
UpdateTable (1) '' function that updates table in the dataset
grid.BeginUpdate
grid.GridBoundColumns.Clear() If Not (theFilterBar Is Nothing) And (theFilterBar.Wired) Then
theFilterBar.RowFilter = ""
theFilterBar.UnwireGrid()
End If
grid.DataSource = dataset.Tables(1)
grid.Refresh()
grid.EndUpdate()

'' here is the putting it again
dataset.Tables(1).DefaultView.RowFilter() = strFilter
dataset.Tables(1).DefaultView.Sort() = strSort

grid.ForceCurrentCellMoveTo = True
grid.CurrentCell.MoveTo(index, 2)

That''s it... after running this code, the ''none'' option from the FilterBar doesn''t work.

Jose Melo

[Jose Luis Melo]

ups, I forgot...

I''m wireing the FilterBar (and removing the custom option), just before the grid.Refresh with:

theFilterBar.WireGrid(grid)
For col As Integer = 0 To grid.Model.ColCount
Dim dt As DataTable = New DataTable
dt = grdPorAlocar2(1, col).DataSource()
If Not (IsNothing(dt)) Then
dt.Rows.RemoveAt(1)
End If
Next

Jose Melo

[Jose Luis Melo]

Sorry the mistakes before, here is the whole code...

Dim index as integer = grid.CurrentCell.RowIndex
'''' record the filter to a string
Dim strFilter as string = dataset.Tables(1).DefaultView.RowFilter()
Dim strSort as string = dataset.Tables(1).DefaultView.Sort()
UpdateTable (1) '''' function that updates table in the dataset
grid.BeginUpdate
grid.GridBoundColumns.Clear()
If Not (theFilterBar Is Nothing) And (theFilterBar.Wired) Then
theFilterBar.RowFilter = ""
theFilterBar.UnwireGrid()
End If
grid.DataSource = dataset.Tables(1)

theFilterBar.WireGrid(grid)
For col As Integer = 0 To grid.Model.ColCount
Dim dt As DataTable = New DataTable
dt = grid(1, col).DataSource()
If Not (IsNothing(dt)) Then
dt.Rows.RemoveAt(1)
End If
Next

grid.Refresh()
grid.EndUpdate()

'''' here is the putting it again
dataset.Tables(1).DefaultView.RowFilter() = strFilter
dataset.Tables(1).DefaultView.Sort() = strSort

grid.ForceCurrentCellMoveTo = True
grid.CurrentCell.MoveTo(index, 2)

[Administrator]

You are setting

theFilterBar.RowFilter = ""

How about saving this value and also reset it after you rewire the grid and reset the RowFilter.

[Jose Luis Melo]

Yes, it solved the problem... I was only loading the dataset RowFilter and not the FilterBar RowFilter.

I thought the dataset RowFilter, after the Bar being wired, would copy its value to the FilterBar... anyway, my fault, i never saw it''s value, and check it.

Thanks a lot for your time once again,
Jose Melo