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>