CODEWITHSUNDEEP
c#asp.netxmldatasetresultset
mahesh
mahesh

Reputation: 3207

How to construct a xml file from dataset

I have the query which gives me the status value , where the query output is stored in the ResultSet,

IResultSet resultSet = dbManager.Provider.GetData(dataOperation);

How can i construct the xml of following type , with the value node data in the xml tag should be set with value in the ResultSet 

<Chart editMode='1' bgColor='FFFFFF' bgAlpha='0' showBorder='0' upperLimit='1000' lowerLimit='0' numberPrefix='$' gaugeRoundRadius='5' chartBottomMargin='30' ticksBelowGauge='0' placeTicksInside='0' showGaugeLabels='0' pointerOnTop='1' pointerRadius='14' chartLeftMargin='25' chartRightMargin='30' majorTMColor='868F9B' majorTMHeight='10' majorTMThickness='2' pointerBgAlpha='0' pointerBorderThickness='2' majorTMNumber='0' minorTMNumber='0' showToolTip='0' decimals='0'>

    <colorRange> 
        <color minValue='0' maxValue='100' code='F6BD0F' />
    </colorRange>

    <value>665</value>

    <trendpoints>
        <point value='350' fontcolor='FF4400' useMarker='0' dashed='1' dashLen='1' dashGap='3' markerRadius='5' color='FF654F' alpha='100' thickness='2'/>
        <point value='800' fontcolor='FF4400' useMarker='0' dashed='1' dashLen='1' dashGap='3' markerRadius='5' color='8BBA00' alpha='100' thickness='2'/>
    </trendpoints>

    <annotations>
        <annotationGroup id='Grp1' showBelow='1'>
            <annotation type='rectangle' x='2' y='2' toX='445' toY='95' radius='10' fillColor='D6E0F6' fillAngle='90' borderColor='868F9B' borderThickness='2'/>
        </annotationGroup>
    </annotations>

    <styles>
        <definition>
            <style name='ValueFont' type='Font' bgColor='333333' size='10' color='FFFFFF'/>
            <style name='RectShadow' type='Shadow' strength='3'/>
        </definition>
        <application>
            <apply toObject='VALUE' styles='valueFont'/>
            <apply toObject='Grp1' styles='RectShadow' />
        </application>
    </styles>
</Chart>

Upvotes: 0

Views: 314

Answers (2)

Anton Vidishchev
Anton Vidishchev

Reputation: 1389

If you are implementing your own XML structure, it's worth using Linq to XML instead of using StringBuilder.

Check out this article, it should help.

Upvotes: 2

Davide Piras
Davide Piras

Reputation: 44595

not sure if:

IResultSet resultSet = dbManager.Provider.GetData(dataOperation);

is actually a dataset object, does not seem like...

in ADO.NET Syste.Data.DataSet object has a method to write the XML file of the contained data, see here:

DataSet.WriteXml Method

calling that method you are ok and you can then inspect the generated XML file.

in your question's title you are asking how to create an XML from dataset not from an IResultSet

Upvotes: 2

Related Questions