question about XML form of dataset
i do have a dataset containing some tables (retrieved from a SQL query). when i make a myDataset.WriteXML it gives me an XML file i'd like to transform later by myself. The problem is that the XML structure is not very good, the nodes struture is not like what i'd like.
Is there a way to customize the XML structure so that the WriteXML() gives me exactly what i want ?
============================
example :
i get this
<BudgetItemXML>
<SERV_ServiceName>Translation</SERV_ServiceName>
<CAT_CategoryName>Other translation</CAT_CategoryName>
<BIT_ItemName>test 2 </BIT_ItemName>
<PC_PriceCodeName>XltTranslatorHour</PC_PriceCodeName>
</BudgetItemXML>
<BudgetItemXML>
<SERV_ServiceName>Translation</SERV_ServiceName>
<CAT_CategoryName>Software translation</CAT_CategoryName>
<BIT_ItemName>test 1 </BIT_ItemName>
<PC_PriceCodeName>XltSoftwareWord</PC_PriceCodeName>
</BudgetItemXML>
<BudgetItemXML>
<SERV_ServiceName>Translation</SERV_ServiceName>
<CAT_CategoryName>Software translation</CAT_CategoryName>
<BIT_ItemName>test 1 </BIT_ItemName>
<PC_PriceCodeName>XltSoftwareWord</PC_PriceCodeName>
</BudgetItemXML>
i want this :
<SERV_ServiceName name="Translation">
<CAT_CategoryName name="Other translation">
<BudgetItemXML>
<BIT_ItemName>test 2 </BIT_ItemName>
<PC_PriceCodeName>XltTranslatorHour</PC_PriceCodeName>
</BudgetItemXML>
</CAT_CategoryName>
<CAT_CategoryName name="Software translation">
<BudgetItemXML>
<BIT_ItemName>test 1 </BIT_ItemName>
<PC_PriceCodeName>XltSoftwareWord</PC_PriceCodeName>
</BudgetItemXML>
<BudgetItemXML>
<BIT_ItemName>test 1 </BIT_ItemName>
<PC_PriceCodeName>XltSoftwareWord</PC_PriceCodeName>
</BudgetItemXML>
</CAT_CategoryName>
</SERV_ServiceName>

