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

Recommended Answers

All 2 Replies

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

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, learning, and sharing knowledge.