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 <http://www.linkedin.com/in/kairaria> “"Courage is the discovery that you may not win, and trying when you know you can lose." - Tom Krause<http://www.quotesdaddy.com/quote/389479/tom-krause/courage-is-the-discovery-that-you-may-not-win-and> ” Get this email app! <http://www.wisestamp.com/apps/quotes?utm_source=extension&utm_medium=email&utm_term=quotes&utm_campaign=apps>
Free signature tool. <http://r1.wisestamp.com/r/landing?promo=32&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_32> CLICK HERE TO GET IT.<http://r1.wisestamp.com/r/landing?promo=32&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_32>
_______________________________________________ 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