datagrid hide row

I have a datagrid view in a windows form
the datagrid is filled with data from a access datatable.

eatch row reprecents a order in the program.

one of the colums is called (ready) end contains a check box.
now i like to hide each order where the check box is true.

so that only the Rows(order's ) that are not ready yet are visible

and the rows that are ready been hide so that the datagrid only contain open orders

how can i do that

Paula Mansour
In my case i have used the folowing code

Dim theDataView As New EK1afkset

theDataView.RowFilter = "Afgehandeld=True"

Me.DataGridView1.DataSource = theDataView

=====================================
EK1afkset is the name of the dataset i curently use

i get the next error "Rowfilter is not a member of ek1afkset"

can anyone tell what i do wrong

Harry
eljefe77
it workt

this code did the job

Dim dv As DataView = New DataView(EK1afkset.Afwijkende_producten)

Me.DataGridView1.DataSource = dv

dv.RowFilter = "[Afgehandeld] =' False '"

harry
agentf1
how do i create a dataview.

the dataset i now use is adit to the form and is loaded whit the folowing code

Me.Afwijkende_productenTableAdapter.Fill(Me.EK1afkset.Afwijkende_producten)

and connected with a binding source to the datagrid.

Harry
Ethan Hunt

You may filter the result like this,

Dim theDataView as new DataView(theDataSet)

theDataView.RowFilter = "Ready=True"

Me.theDataGridView.DataSource = theDataView
BearLine
DataSet class has no the filter property, you should create a dataview from a dataset first
datagrid hide row