Solved

how to search a dataset

Posted on 2006-11-28
3
195 Views
Last Modified: 2010-04-23
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
Comment
Question by:maxgall
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Kinger247 earned 250 total points
Comment Utility
Can you use a select like :

Dim DataRows() As DataRow = dsPupilRecords.Tables(0).Select("[First Name]='Ben' AND [Last Name]='Sherman'")
0
 

Author Comment

by:maxgall
Comment Utility
yes, working fine . thanks vm
0
 
LVL 10

Expert Comment

by:Kinger247
Comment Utility
no problem.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now