datasets and XML

[Dave]

Hi,

I have the following data I want to produce from a dataset.

<Request>
<Ref>123</Ref>
<RefType>Search</RefType>
<CriteriaList>
<Criteria Type="Detail">XXX123</Criteria>
<Criteria Type="Detail">XXX345</Criteria>
<Criteria Type="Summary">XXX678</Criteria>
</CriteriaList>
</Request>

I am getting the Ref, RefType, Criteria and Type information from a SQL
table but when I try to produce XML which looks like the above the best I
can get it is as below:

<NewDataSet>
<Request>
<Ref>123</Ref>
<RefType>Search</RefType>
</Request>
<CriteriaList>
<Criteria>XXX123</Criteria>
</CriteriaList>
<CriteriaList>
<Criteria>XXX345</Criteria>
</CriteriaList>
<CriteriaList>
<Criteria>XXX678</Criteria>
</CriteriaList>
</NewDataSet>

I'm returning two recordsets from SQL (from an SP) and creating a
DataRelation on CriteriaList:

Ref RefType CriteriaList
TG0001 Search_Order NULL

CriteriaList Criteria
NULL 654
NULL AUTOGEN
NULL AUTOGEN

Am I lost here or what? Any help would be appreciated?

Thanks,
Dave

 

[Zürcher See]

You have used the Dataset.WriteXml() method, that is an "xml object
serialization" method.

If you want a different xml output take a look to the XslTransformation:

http://msdn.microsoft.com/library/d...l/frlrfSystemXmlXslXslTransformClassTopic.asp

Here, there is an example

http://msdn.microsoft.com/library/d...rfSystemXmlXslXslTransformClassLoadTopic2.asp

Sorry I never used it, so more than that I cannot help you