Want the NULL mapped tag to be missed when generating XML from XSD using serialize

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » XML » Want the NULL mapped tag to be missed when...

Want the NULL mapped tag to be missed when generating XML from XSD using serialize

Rate Topic

Display Mode

Topic Options

Author

Message

namrata.dhanawade-1143388

Posted Friday, January 11, 2013 12:10 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:17 AM
Points: 75, Visits: 174

Hi,

I have a certain set of minoccurs = 0 in my XSD.
When mapping data to the class that I created using this XSD, it is found that the database is returning NULL for certain properties.

I do not want these NULL property elements to appear in the XML

Eg:
<xs:element name="MyLevel" minOccurs = "0" type="xs:string"/>
<xs:element name="YourLevel" minOccurs = "0" type="xs:string"/>
<xs:element name="HisLevel" minOccurs = "0" type="xs:string"/>
<xs:element name="HerLevel" minOccurs = "0" type="xs:string"/>

Now if the database returns
MyLevel as "20"
YourLevel as NULL or Empty
HisLevel as "30"
HerLevel as "40"

I would like the XML to look like
<MyLevel>20</MyLevel>
<HisLevel>30</HisLevel>
<HerLevel>40</HerLevel>

But I instead get
<MyLevel>20</MyLevel>
</YourLevel>
<HisLevel>30</HisLevel>
<HerLevel>40</HerLevel>

Is there a certain property or condition that I may be missing? Is it possible to get the result I am looking for without using an if..else condition when mapping my dataset to the XSD object?

HELP!!

Post #1405783

« Prev Topic | Next Topic »

Permissions