Problem getting the right output from my typed dataset

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • TheLongshot

    Problem getting the right output from my typed dataset

    I have a typed dataset which I used to generate an export file in XML
    which is consumed by another program. What I'm having a problem is
    that some of the elements aren't coming out the way I need them.

    For example, I have a section (which is a child table for my record)
    which keeps track of security accesses. The problem is, I need the
    output to come out like this:

    <SecurityAccess >
    <Access>AA</Access>
    <Access>BB</Access>
    </SecurityAccess>

    Instead, it comes out like this:

    <SecurityAccess >
    <Access>AA</Access>
    </SecurityAccess>
    <SecurityAccess >
    <Access>BB</Access>
    </SecurityAccess>

    How do I get it to come out the way I want it to?

    The schema fragment that defines this section:

    <xs:element name="SecurityA ccess" minOccurs="0" maxOccurs="1">
    <xs:complexType >
    <xs:sequence>
    <xs:element name="Access" type="AccessTyp e" minOccurs="1"
    maxOccurs="unbo unded" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>

    With Access Type defined as a xs:string with restrictions.

    Any suggestions?
Working...