DataSet/DataTable relationships question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi..

I've been working with standalone DataSets and DataTables. I've defined a schema to model some xml data like the following
<Root><Client id="1" total="Sum(Child(rel).cost)" updated="Max(Child (rel).updated"><Order id="1" cost="12" updated="<date>"/><Order id="1" cost="3" updated="<date>"/
..
</Client
..
</Root

With the schema to represent this, I end up with 2 tables, Client and Order with a relationship defined making Order the child of Client. Two columns in Client are defined as operations on the child table orders

The problem I'm running into now is that after the first query on Client, total and updated both get set according to the current state of Order but never get updated again. Subsequent queries on Client after there have been changes on Order don't reflect the Order changes

Is there a way to structure this or a flag to set to allow this to work

Thank
-Mar
 
Hi Mark,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you were unable to get the changes made
to the DataSet in Xml. If there is any misunderstanding, please feel free
to let me know.

I would like to know how did you query the Order and Client table. What
have you modified? Also, what's the state you mentioned in your post? Do
you mean that the Xml data got from the DataSet.GetXml() remains the same
even you have made changes to the data in DataSet? Please provide me with
more information, so that we can deliver our assistance more quickly. Thank
you!

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Hi Mark,

Thanks for clarify things. I have tried the way you mentioned. However, I
cannot reproduce it on my machine. Could you show us the DataSet schema and
the code how you get the XmlDataDocument? Thanks!

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Hi Mark,

Remove online from the no spam email address is my real email address.
Please feel free to send me the repro package if it smaller than 4MB. I
will try my best to help.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Hi Mark,

Thanks for letting me know. I think Microsoft PSS will help you work out
the problem very soon.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top