469,934 Members | 1,873 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Filtering relational dataset tables by parent record

Good morning,

I have a typed dataset with 10 relational, hierarchical tables. I
want to be able to "filter" all the dataset tables based on one parent
record. For instance, let's say I have a dataset that with 10 tables
that contain information about all of the 40 some odd U.S.
presidents. The main parent table would be the "President" table.
The child, grandchild, great-grandchild etc. tables may include
countries the president visited, places he lived, children he had and
where they lived, etc. I want to be able to do something like "Filter
the dataset by LastName='Lincoln'", and then the dataset tables would
just contain all records corresponding to Abraham Lincoln.

I studied the DefaultView and the GetChildRows, but it doesn't seem to
give me what quite what I want, unless I am doing it wrong.

I guess I just want a filtered dataset. Using the example above, I
could filter by Abraham Lincoln and easily populate my controls. The
user can change the data, and refresh the page then I could show a
different president, etc. When it's all over I send my dataset out
for update.

Thanks for the help.

Feb 22 '07 #1
0 1105

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by MajorTom | last post: by
2 posts views Thread by Darren Clark | last post: by
reply views Thread by Raed Sawalha | last post: by
3 posts views Thread by Shahriar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.