Repetetive XML tags
Posted: Thu Apr 03, 2008 6:11 pm
Hi,
I am reading a dataset and creating output XML.
Here is the XML output I am getting.
<Message>
<Main>
<Col1>18108</Col1>
<Col1>18108</Col1>
<Col1>18108</Col1>
<Col2>U00009473</Col2>
...............
</Main>
</Message>
First Column is repeting 3 times as the I have 3 rows present for that same key field.
I had used the key field that is specified in the dataset as the Trigger Column.
Can anyone please help me to get one row as Col1 in the XML output irrespective of duplicate rows.
Cheers
Debasis
I am reading a dataset and creating output XML.
Here is the XML output I am getting.
<Message>
<Main>
<Col1>18108</Col1>
<Col1>18108</Col1>
<Col1>18108</Col1>
<Col2>U00009473</Col2>
...............
</Main>
</Message>
First Column is repeting 3 times as the I have 3 rows present for that same key field.
I had used the key field that is specified in the dataset as the Trigger Column.
Can anyone please help me to get one row as Col1 in the XML output irrespective of duplicate rows.
Cheers
Debasis