SQLServerCentral / Programming / XML / Want the NULL mapped tag to be missed when generating XML from XSD using serialize / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 15:54:54 GMT20Want the NULL mapped tag to be missed when generating XML from XSD using serializehttp://www.sqlservercentral.com/Forums/Topic1405783-21-1.aspxHi,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 XMLEg: <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 EmptyHisLevel 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!!Fri, 11 Jan 2013 00:10:19 GMTnamrata.dhanawade-1143388