• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • Last Modified:

MS-Q325695 .NET Datasets require that a table can only be a child of one other table.

Dear Experts

Is there a solution for this problem?

MS-Q325695
.NET Datasets require that a table can only be a child of one other table.
http://support.microsoft.com/kb/325696/

I cannot modity the xml file because it is from a third party source.
Upgrading from VS.NET 2003 is not an option.

How do I get around this problem?

Please help
0
narmi2
Asked:
narmi2
  • 2
1 Solution
 
Bob LearnedCommented:
None that I know of.

Bob
0
 
JimBrandleyCommented:
If your problem is similar to the one shown in the article, then one possible solution is use XSL to transform the repeated element names under different parents when you read th XML. For example,
<?xml version="1.0" ?>
<OrdersInventoryData>
      <Order>
            <Item>
                  <id>1</id>
                  <qty>5</qty>
            </Item>
      </Order>
      <Inventory>
            <Item>
                  <id>1</id>
                  <qty>100</qty>
            </Item>
      </Inventory>
</OrdersInventoryData>

becomes:
<?xml version="1.0" ?>
<OrdersInventoryData>
      <Order>
            <Item>
                  <id>1</id>
                  <qty>5</qty>
            </Item>
      </Order>
      <Inventory>
            <InvItem>
                  <id>1</id>
                  <qty>100</qty>
            </InvItem>
      </Inventory>
</OrdersInventoryData>

Jim
0
 
narmi2Author Commented:
So how would I go about creating this xslt file?
0
 
JimBrandleyCommented:
It has to match your XML, so would depend on what it contains.

Jim
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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