Dataset.WriteXml how to skip DBNull elements when writing to XML?

[leonards]

Hello

I have the opposite problem as
http://www.thescripts.com/forum/thread176792.html

When I'm writng XML files with
report.WriteXml(scriptName +".xml",XmlWriteMode.WriteSchema);

The write method writes out post which are DBNull to the xml document. Then when I read the document using
report.ReadXml(script, XmlReadMode.ReadSchema);
I retrieve a dataset where values which should be null are EmptyString.

Are there any why I can write to xml and skip writing DBNull elements?




(Yes, Default value for elements that should be DBNull is DBNull)

Regards Leonard

[Airslash]

Hello

I have the opposite problem as
http://www.thescripts.com/forum/thread176792.html

When I'm writng XML files with
report.WriteXml(scriptName +".xml",XmlWriteMode.WriteSchema);

The write method writes out post which are DBNull to the xml document. Then when I read the document using
report.ReadXml(script, XmlReadMode.ReadSchema);
I retrieve a dataset where values which should be null are EmptyString.

Are there any why I can write to xml and skip writing DBNull elements?




(Yes, Default value for elements that should be DBNull is DBNull)

Regards Leonard

eum, check the value before writing, and only write if it has the correct value ?

[leonards]

That should not be necessary, there should be a way to not print out DBNull elements.