XML Format

[hilfy]

I'm building a web service that will serve data to a dashboard that's been created in Xcelsius. Ideally, it will be returning multiple tables in a single result. After doing a lot of research, I've determined that in order for Xcelsius to be able to read it (Xcelsius won't read complex data types...), the format for the tables needs to be something like this:

<Table1Name>
  <row>
    <column>Column1Name</column>
    <column>Column2Name</column>
  </row>
  <row>
    <column>Row1Data1</column>
    <column>Row1Data2>/column>
  </row>
...
</Table1Name>
<Table2Name>
  <row>
    <column>Column1Name</column>
etc.

My data is in tables in a DataSet.

I haven't done a lot of work with XML so I'm not sure how to transform things to get this format in my output. Does anyone have any suggestions?

Thanks!

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[jmeckley]

look into the dataset members specifically GetXml(), ReadXml(...) and WriteXml(...)

Jason Meckley
Programmer
Specialty Bakers, Inc.