Solved

Binding a specific record

Posted on 2006-06-29
1
174 Views
Last Modified: 2010-04-23
Hi gang!

I am trying to create a control panel type application that gets lists of items and sub-items from a webservice and puts them into a dataset. Then the application parses through them to generate ListViewItems with a two part tags e.g. "CNT:ESP" (so I know what to do when its clicked because some are folders and some are items, the example is "Country" and "Spain").

When called I want to call a specific record into a form so items can be changed but I can't get my head around binding with a key rather than a position... especially as some of forms need to access lookup data via a relationship.

Tables look like this:

GEODATA_CURRENCIES
code (EUR/USD/GBP etc)
name (Euro, US Dollar, British Point etc)

GEODATA_COUNTRIES
code (ESP/USA/GBR)
name (Spain, United States, Great Britain)
currency_code (EUR/USD/GBP lookup)

Say for example my user opens the form and wants to see "Spain", how? The tag for the item s/he opens would be CNT:ESP

Thanks!
setsquare
0
Comment
Question by:setsquare
[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
1 Comment
 
LVL 96

Accepted Solution

by:
Bob Learned earned 125 total points
ID: 17010665
You could use a filter with the DataTable's DefaultView:

Dim table As DataTable = ds.Tables(0)
table.DefaultView.RowFilter = "code='USD' "

Bob
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

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

Suggested Solutions

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

735 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