• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

how to search a dataset

In my application I have a dataset which I fill on start of the application.

        Me.taPupilRecords.Fill(Me.dsPupilRecords.pupilRecords)
The dataset has two colums    "First Name"   "Last Name"

I would like to search the dataset for a name and display the name in a textbox.   Could you please tell me the easiest way to do that.
I seem to be stuck on this.

thanks

Max
0
maxgall
Asked:
maxgall
  • 2
1 Solution
 
Kinger247Commented:
Can you use a select like :

Dim DataRows() As DataRow = dsPupilRecords.Tables(0).Select("[First Name]='Ben' AND [Last Name]='Sherman'")
0
 
maxgallAuthor Commented:
yes, working fine . thanks vm
0
 
Kinger247Commented:
no problem.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now