Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

500pts: Navigating a dataset with a relationship

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
ianinspain
Asked:
ianinspain
2 Solutions
 
redpipeCommented:
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
 
Gautham JanardhanCommented:
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
 
ianinspainAuthor Commented:
Excellent .. thanks for your help..... working great now... thanks...
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now