Dataset.GetXML() method doesn't Return Null Values. Any Solution?

[Nanda]

Hi All,

Thanks for u r Valuable postings.
Here is a Problem for me.

I need to reprsent the NULL value of a column in Database in an XML
File as follows.

<Employees>
<Employee>
<Name>John</Name>
</Addr>
<City>NewYork</City>
</Employee>
</Employees>

Here </Addr> represents a null field in Database.
But using Dataset.GetXML() method I am getting the XML O/p as follows.
<Employees>
<Employee>
<Name>John</Name>
<City>NewYork</City>
</Employee>
</Employees>

Can Any body help me from this situation?
Thanks in Advance
Regards
Nanda

 

[Kalpesh]

Hi,

This is because it is containing NULL (DBNull.Value) - it is being
ignored.
Maybe, you can traverse for column having DBNull.Value & make it blank

Then, I guess it should emit XML the way you want

HTH
Kalpesh