Solved

500pts: Navigating a dataset with a relationship

Posted on 2006-11-03
3
338 Views
Last Modified: 2010-04-16
Hi there,

Can anyone help, i imported an xml file into a dataset using dataset.readxml... and it  is working great..

It also has relationships....

How would i navigate the dataset i.e. movenext, first, last etc ... and taking into consideration that when the main table moves to record 2 ... then the relationship tables also move?

There are currently 3 tables in the dataset and the data is there...

I am just a bit unclear how to navigate it using the relationships

Thanks in advance

ian
0
Comment
Question by:ianinspain
[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
3 Comments
 
LVL 8

Accepted Solution

by:
redpipe earned 250 total points
ID: 17865480
Try the following how-to's from Microsoft with comments and source code (the latter is for office):

Navigating a Relationship Between Tables
http://msdn2.microsoft.com/en-us/library/d6s958d6.aspx

Walkthrough: Creating a Master/Detail Relation Using a Cached Dataset
http://msdn2.microsoft.com/en-us/library/ms178809.aspx
0
 
LVL 29

Assisted Solution

by:Gautham Janardhan
Gautham Janardhan earned 250 total points
ID: 17865560
this is for a cached data set

private void btnNext_Click(object sender, System.EventArgs e)
            
{
this.BindingContext[objCustOrd,"Customers"].Position = (this.BindingContext[objCustOrd,"Customers"].Position + 1);


}
0
 

Author Comment

by:ianinspain
ID: 17888429
Excellent .. thanks for your help..... working great now... thanks...
0

Featured Post

Industry Leaders: 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

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…

749 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