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