DataSet XML export is empty

Question

I've got in-memory dataset with couple of tables that is populated in code. Data-bound grids on the gui show table contents without a problem.

Then I try to export the dataset into XML:

ds.WriteXml(fdSave.FileName, XmlWriteMode.WriteSchema);

and get empty XML (with couple of lines regarding dataset names but without any tables)

If I export table directly I've got all the data but dataset name is obviously wrong:

ds.Fields.WriteXml(fdSave.FileName, XmlWriteMode.WriteSchema);

What am I missing? Is there any reasonable way to write the whole dataset into file?

Answer 1

Have a look at the documentation on DataSet.WriteXml:

http://msdn.microsoft.com/en-us/library/ms135425.aspx

and on XmlWriteMode:

http://msdn.microsoft.com/en-us/library/system.data.xmlwritemode.aspx

Try using XmlWriteMode.IgnoreSchema. The docs say for XmlWriteMode.WriteSchema "If the DataSet does not have a current schema, nothing is written."

Answer 2

ok, silly me. was clearing dataset tables collection before populating it...