Xml from dataset

May 19 2008 7:15 AM
 

Hi All,

I have a dataset  filled with some rows.

I write it in xml file. then it give me structure like this. 

<Table>

<REGION>YZ</REGION>

<AREA>xyz</AREA>

<MONTH>5</MONTH>

<YYMM>200805</YYMM>

</Table>

<Table>

<REGION>XY</REGION>

<AREA>abc</AREA>

<MONTH>6</MONTH>

<YYMM>200806</YYMM>

</Table>

 

But i want a change in this structure that i can find some unique id per table like this (mention bold and italic)

 

<Table id=200805>

<REGION>YZ</REGION>

<AREA>xyz</AREA>

<MONTH>5</MONTH>

<YYMM>200805</YYMM>

</Table>

<Table id=200806>

<REGION>XY</REGION>

<AREA>abc</AREA>

<MONTH>6</MONTH>

<YYMM>200806</YYMM>

</Table>

 

Please give me some suggesion .......


Answers (1)