Member Avatar for warun

Dear All

can we filter subset of DataSet.Table row collection in ADO.Net. Early days adodb's recordset was providing Filter method to get subset of its records, but i couldn't find a similar option in ado.net.

thanks in advance and looking for your immediate suggestions

Warun

  • 3 Contributors
  • 2 Replies
  • 152 Views
  • 10 Months Discussion Span
  • Latest Post Latest Post by doleh
Member Avatar for ptaylor965

Yes you can filter the dataset table rows.

Use the select command

Dim Row as Datarow

For Each Row in Dataset.Tables(0).Select("Column = 'Find Me'")
   MsgBox(Row("Column").ToString)
Next
Member Avatar for doleh

Ilove this site

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.