Write data to XML from datareader

MiniAcele

New Member
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:\[code\]Batch Image name age1 1 Alfa 201 2 Beta 141 2 Theta 461 2 omega 9\[/code\]How can get this output into this format:\[code\]<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>\[/code\]Help a newbie.
 
Back
Top