Solved

500pts: Navigating a dataset with a relationship

Posted on 2006-11-03
3
329 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
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Bit flags and bit flag manipulation is perhaps one of the most underrated strategies in programming, likely because most programmers developing in high-level languages rely too much on the high-level features, and forget about the low-level ones. Th…
Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now