The simplest way to do this is as following
  1. Sort your data by batch and then by image
  2. Loop through the data row by row
  3. Write a series of nested loops, the outer one writing the begin tag for the batch, the next the begin tag for the image and the third the begin and end tags for name and age

On Wed, Oct 10, 2012 at 2:58 AM, Kennedy Kairaria <kenkairaria@gmail.com> wrote:

I am creating an XML where I want to export all my data from a table in conformance to a certain schema. I am using an XMLTextwriter since I also have custom tags,

The data in my table looks like:

Batch Image   name  age

1       1     Alfa  20
1       2     Beta  14
1       2     Theta 46
1       2     omega  9

How can get this output into this format:

<Batch name='1'>
 
<Image name='1'>
     
<fld name>Alfa</fld>
     
<fld age>20</fld>
 
</image>
 
<Image name='2'>
     
<fld name>Beta</fld>
     
<fld age>14</fld>
     
<fld name>theta</fld>
     
<fld age>46</fld>
     
<fld name>omega</fld>
     
<fld age>9</fld>
 
</image>
</Batch>


Kennedy Nyagah Njagi Kairaria IT Support-Applications development, Digital Divide Data
Tel: 254 772191795 | Mobile: 254 724615232
kennedy.kairaria@digitaldividedata.com | www.digitaldividedata.com


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke