Vb.net datagridview

You can create filtered dataview and use it as a datasource for bindingsource

Dim dt As New DataTable
'... fill datatable
Dim view As New DataView(dt)
view.RowFilter = "myColumn>5" 'your filter here
Dim bs As New BindingSource
bs.DataSource = view
grid.DataSource = bs

Select allOpen in new window

Hi,

I'm not sure how to do the dataview that way,

This is how I bind my datagridview

        clientAccessData = New ClientsAccess
        cliAccDataSet = clientAccessData.getrelateddata
        cliAccessBindingsource = New BindingSource

        With cliAccessBindingsource
            .DataSource = cliAccDataSet
            .DataMember = "projets"
        End With

  DataGridView1.DataSource = cliAccessBindingsource

cliAccessBindingsource.Filter = "prjNumber like '%bs%' AND prjStage<>'Completed' and prjStage<>'Inactif'"

Select allOpen in new window

Dim view = New DataView(cliAccDataSet.Tables("projets"))
view.RowFilter = "prjNumber like '%bs%' AND prjStage<>'Completed' and prjStage<>'Inactif'"

cliAccessBindingsource.DataSource = view

DataGridView1.DataSource = cliAccessBindingsource

Select allOpen in new window

The result is the same though,

If I change values in the datagrid the row still gets filtered out off the screen,

what is the advantage of creating a view.

My problem was this:

Filter all rows that contain the employee John
The datagridview shows 5 rows that contain John
I then change the employee name in those rows to Fred
As I change the name to Fred the rows dissapear off the grid (because it is filtering only those that contain John)

When I try to save it, the changes I made don't register, some times it saves 3 out of the 5 changes I made, some times 1, sometimes it gives me an error.