When using the getXML() method of a dataset, I have noticed that every field in a column is null, the XML produced does not have any elements that correspond to the empty column.

EG.

table structure:

col1 : A value

col2 : NULL

col3 : ANother value

XML produced:

<col1>A value</col1>

<col3>ANother value</col3>

Is there an easy way to ensure that the null column is represented in the XML (in the above example, col2) ?

Cheers

Mark

• No Related Post