Changing the xml structure when I use WriteXML converting DataSet to xml?

Asked Jul 23 '14 at 18:21

Active Jul 23 '14 at 18:21

Viewed 75 times

The following puts content of an excel file (one worksheet; one column) into a DataSet that needs to be an excel string:

enter image description here

        DataSet ds = excelReader.AsDataSet();

        StringWriter sw = new StringWriter();
        ds.WriteXml(sw);
        string result = sw.ToString();

it returns the following string:

<NewDataSet>
<Sheet2><Column1>70209429072734</Column1></Sheet2>
<Sheet2><Column1>30221442748624</Column1></Sheet2>
<Sheet2><Column1>70209433124464</Column1></Sheet2>
<Sheet2><Column1>30209434466634</Column1></Sheet2>
</NewDataSet>

I want it in this format:

<DLN>
   <id>70209429072734</id>
   <id>30221442748624</id>
   <id>70209433124464</id>
   <id>30209434466634</id>
</DLN>

asked Jul 23 '14 at 18:21

Chaka

1,709
11
33
58

Possible duplicate of [C# Find And Replace XML Nodes](http://stackoverflow.com/questions/6794027/c-sharp-find-and-replace-xml-nodes) ? – Scott Solmer Jul 23 '14 at 18:44
Anyway to avoid needing to iterate thru records to create my format? – Chaka Jul 23 '14 at 18:50
I doubt it. If it's possible I'd love to know how as well. – Scott Solmer Jul 23 '14 at 18:52

Changing the xml structure when I use WriteXML converting DataSet to xml?

0 Answers0