I am using a Dataview to filter rows of data from a table in MSDE.
My controls are placed on a Windows form, contain a datagrid, textboxes and naviagation buttons (btnNext, btnPrevious..)
I use a BindingManagerBase for navigation.
My problem is this: When I filter the Dataview, the filtered rows are dispalyed in the datagrid, but the textboxes remain unchanged displaying data from the first record in the table, although they are bound to the Dataview. Also the navigation buttons work in the same way before the data was filtered, moving between the first and last record in the table.
What I needed was to show the filtered records in the datagrid and to have the navigation buttons only move between the filtered records.