How to write C# DataSet object to XML with customized nodes structure?

Question

I have a similar case - I receive a DataSet object with data tables willed with data (e. g. customers table ...) from an external module (done by other programmer).

I then save the data set object to an xml using the writeXml method - here is my code

public void Save(string myXmlFilePath)
{        
    XmlWriterSettings settings = new XmlWriterSettings();
    settings.Encoding = System.Text.Encoding.UTF8; 
    settings.Indent = true;
    settings.NewLineHandling = NewLineHandling.None;

    using (XmlWriter writer = XmlWriter.Create(myXmlFilePath, settings))
    {
        ExportObject.WriteXml(writer);
        writer.Close();
    }
}

I get the standard xml file output structure like this:

<NewDataSet>
    <Customers>...</Customers>
    <Customers>...</Customers>
<NewDataSet>`

However I want the structure like this

<Customers>
    <Customer>...</Customer>
    <Customer>...</Customer>
</Customers>`

How can I achieve this?

score 0 · Answer 1 · answered Jul 12 '18 at 16:44

0

Specify the desired names to the dataset and the tables within it.

ExportObject.DataSetName = "Customers";
ExportObject.Tables[0].TableName = "Customer";

answered Jul 12 '18 at 16:44

Alexander Petrov

13,457
2
20
49

That's what I also thought, so I did name all the tables in the data set. This did not help – anar chipur Jul 12 '18 at 17:47
I understand you - if I had only one table this would work but I have many tables like Customers, Products etc. so just naming the data set as "Customers" will not do the job – anar chipur Jul 12 '18 at 17:49
One possible solution that I just found is: – anar chipur Jul 12 '18 at 20:16

score 0 · Answer 2 · answered Jul 12 '18 at 21:32

0

A work around is to let WriteXml write however it likes and then do an XSD transform to the format you prefer.

answered Jul 12 '18 at 21:32

LosManos

7,195
6
56
107

How to write C# DataSet object to XML with customized nodes structure?

2 Answers2