XML file w ith parent / child relationship

bh0526 · June 13th, 2003, 01:31 PM

Hi all,

I want to create an xml file that will be based on the same structure as my sql database which consists of 4 tables. Here are the 4 tables and the columns within each table:

Code:

BrochureHeader
  Columns
    BrochureID
    BrochureName

BrochureMerchant
  Columns
    BrochureID
    MerchantRow

BrochureSpot
  Columns
    BrochureID
    MerchantRow
    SpotNum

BrochureLine
  Columns
    BrochureID
    MerchantID
    SpotNum
    LineNum
    CopyText

I want my XML File to appear as follows:
<Level1>
  <BrochureName>ABC School</BrochureName>
   <Level2>
    <MerchantRow>1</MerchantRow>
      <Level3>
        <SpotNum>1</SpotNum>
         <Level4>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
         </Level4>
      </Level3>
      <Level3>
        <SpotNum>2</SpotNum>
         <Level4>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
         </Level4>
      </Level3>
   </Level2>
   <Level2>
    <MerchantRow>2</MerchantRow>
      <Level3>
        <SpotNum>1</SpotNum>
         <Level4>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
         </Level4>
      </Level3>
      <Level3>
        <SpotNum>2</SpotNum>
         <Level4>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
           <CopyText>Some Text</CopyText>
         </Level4>
      </Level3>
   </Level2>
</Level1>

I am having a terrible time getting this to work. I hate to post my code at this point because it doesn't work. I creating a dataset for each of my tables and I have messed around with the datarelation class but I have not had much luck. DOes anyone know of a web site that creates an XML file with similar hiearchy or does anyone have some code they can share?

Thanks,
Bob

Phillip · June 13th, 2003, 05:21 PM

If you are using Visual Studio .net you can quite easily create a typed Dataset that will reveal an XML schema that you can use to produce XMl that reflects the rules of the database.

Its quite easy to get an XML representation of a dataset, so why dont you just write code that produces a dataset then persist it to XML and see what it looks like?

Quote:

quote:Originally posted by bh0526

I want to create an xml file that will be based on the same structure as my sql database which consists of 4 tables. Here are the 4 tables and the columns within each table:

bh0526 · June 16th, 2003, 09:00 AM

Thanks for the response but basically you didn't really provide me with anything that will help me. I am creating a dataset already but I want to create a dataset in such a way that when I write it out to XML it will look like my example. I do not know how to create a dataset that will produce the xml in my original post. ANy help would be appreciated.

Thanks,
Bob

Hal Levy · June 18th, 2003, 08:28 AM

Bob,

I wonder- did you output the XML representation of the dataset as suggested? What does that look like?

Hal Levy
Daddyshome, LLC
NOT a Wiley/Wrox Employee