saving XML including blank value

Question

I have a code in which am saving a dataset value to xml. The values in the dataset are coming from an Excel sheet (.xls format). My problem is that if a value is blank or null, it's ignoring it but I want that it should close the tag for it, e.g <test></test> or </test>.

my code is

daAdapter = new OleDbDataAdapter("Select * FROM [KDC Report$]", connection);
System.Data.DataTable dt = new System.Data.DataTable("Assets");
daAdapter.Fill(dt);
DataSet ds = new DataSet("DocumentElement");
ds.Tables.Add(dt);
var memoryStream = new MemoryStream();

using (TextWriter streamWriter = new StreamWriter(memoryStream))
{
    var xmlSerializer = new XmlSerializer(typeof(DataSet));
    xmlSerializer.Serialize(streamWriter, ds);
    Encoding.UTF8.GetString(memoryStream.ToArray());
}

ds.WriteXml("C:\\Development\\MyAppln\\ExcelToXML\\Products.xml");

@ HimBromBeere : in ds.WriteXml("C:\\Development\\MyAppln\\ExcelToXML\\Products.xml"); i use IsNullable property? — NoviceToProgramming, Oct 14 '13 at 08:38
Possible duplicate: http://stackoverflow.com/questions/254821/xmlserializer-serialize-empty-variable-to-use-both-tags — orel, Oct 14 '13 at 11:32

score 0 · Answer 1 · answered Oct 14 '13 at 11:18

0

You are serializing a DataSet. With datasets you have no control over the XML that is produced.

If you use your own class with properties for all of the fields, you can use the attributes in the System.Xml.Serialization namespace to control serialization.

answered Oct 14 '13 at 11:18

Kris Vandermotten

10,111
38
49

saving XML including blank value

1 Answers1