XML hierarchy

[yablonka]

Hi all,

 

I'm new to XML...I'm trying to populate an XML using data found in SQL server.

 

The database consists of two tables (connected by a simple relationship) of suppliers and their products.

 

To make a long story short, this is the result I'm trying to get:

 

<SuppliersList>
  <Supplier>
     <Name>John</Name>
     <City>New York</City>
     <Product>
        <ProductName>Ballons</ProductName>			
        <ProductType>Children</ProductType>
     </Product>
     <Product>
        <ProductName>Toys</ProductName>			
        <ProductType>Children</ProductType>
     </Product>
  </Supplier>
  <Supplier>
     ...
     <Product>
        ...
     </Product>
  </Supplier>
</SuppliersList>

 

I'm trying to mess around with adapters unsuccessfully.

Any help would be appreciated.