Find and Filter??

[lester]

Hi,

Can someone pls let me know how can I find and filter records in ADO.net??

TIA.

 

[JIMcFadyen]

At what point do you want to filter the records?

There is a property on the DataView called RowFilter that does just that.

John

 

[lester]

In VB6 I can actually find a record in the recordset like this:

recordset.find "ColumnID = 1 "

but how can I do thid in VB.net??

 

[lester]

No one can help??

 

[JIMcFadyen]

There is also a Find method on the DataView

Private Sub FindValueInDataView(t As DataTable)
   Dim dv As DataView
   Dim i As Integer
   dv = New DataView(t)
   dv.Sort = "CusomerID"
    Find the customer named "DUMON" in the primary key column
   i = dv.Find("DUMON")
   Console.WriteLine(dv(i))
End Sub

John