Searching Dataset

  • Thread starter Thread starter Bijoy Naick
  • Start date Start date
B

Bijoy Naick

I have a query whcih returns a dataset. the dataset looks something like
this..

Country, NumEvents
1,0
2,7
3,23
4,3


Given a country ID (1..4), how can I find the corresponding NumEvents
value.

For example, I want to do something like (assuming country ID 3
corresponds to Canada)..

canada.text = myDS.Tables(0).FindValue("country = 3")

Whats the right approach?
 
Hi Bijoy:

Take a look at the DataTable Select method. This will return a row
matching an expression, than you can pull out the other values you
need from that row.

HTH,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

asp:dropdownlist - SelectedItem.Value 2
tearing my hair out 3
Using a SQL statement with variable parameters and variable criteria 1
Unwanted behaviour on browser back button 2
Three Level Repeater Nesting - HELP!!! 1
How to bind a label to a dataset with C# 4
How to do a Select on a DataSet that was read from an Xml file? searching on an element attribute as 8
Adding a datatable to a dataset 1

Back
Top