Solved

how to search a dataset

Posted on 2006-11-28
3
199 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Kinger247 earned 250 total points
ID: 18026696
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
ID: 18026765
yes, working fine . thanks vm
0
 
LVL 10

Expert Comment

by:Kinger247
ID: 18026802
no problem.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
vb.net sendkey 4 31
Set arraylist as datatable 2 29
Help with Report Viewer in VS2013 6 32
Background worker passing messagebox yes no 13 25
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

739 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