write data of unbound datagridview to XML

[Anthoni]

Dear All,
I need to export data of unbound datagridview to XML file.
Since my DataSource is NULL, What other options do I have?
Does i need to make 2 loops (on all the records and inside loop of all
the cells)
read data and export it to XML?
TIA,

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

I see no other option.

You could define a Dataset/DataTable with the correct definition and then
just iterate in the Datagridview rows.

At the end you just use DataSet.WriteXm l

"Anthoni" <de*********@gm ail.comwrote in message
news:11******** **************@ w5g2000hsg.goog legroups.com...

Dear All,
I need to export data of unbound datagridview to XML file.
Since my DataSource is NULL, What other options do I have?
Does i need to make 2 loops (on all the records and inside loop of all
the cells)
read data and export it to XML?
TIA,

[Marc Gravell]

Any reason it must be unbound? If you could declare a simple class to
hold the values, and have a List<YourClasso r BindingList<You rClass>
as the data, then you should be able to simple use the XmlSerializer /
DataContractSer ializer to get fairly standard xml.

Marc

[Anthoni]

Thanks,
It seems that I need to do all the work, the problem is that my
knowlagde in XML is very poor.
therefore, in order to get somthing like
<?xml version="1.0" encoding="iso-8859-1" ?>
<items>
<item>
<item_nameSOM E NAME </item_name>
<item_descripti onDESCRIPTION</item_descriptio n>
</item>
<item>
<item_nameSOM E OTHER_NAME </item_name>
<item_descripti onOTHER_DESCRIP TION</item_descriptio n>
</item>
</items>
Any simple sample to do it?
TIA,

[Marc Gravell]

As a very simple (and equally: untested) example (using XmlWriter):

using (XmlWriter writer = XmlWriter.Creat e("blahfile.xml "))
{
writer.WriteSta rtElement("item s");
foreach(blah in blahs) {
writer.WriteSta rtElement("item ");
// perhaps a foreach on columns here...
writer.WriteEle mentString("ite m_name", blahName);
writer.WriteEle mentString("ite m_description",
blahDescription );
writer.WriteEnd Element(); // end of "item"
}
writer.WriteEnd Element(); // end of "items"
writer.Close();
}

XmlWriter can write to files, streams, text-writers and
string-builders etc - it isn't limited to files. Obviously you need to
change every "blah" to something more useful. If you choose to loop on
the columns, you might be able to use part of the column headers for
the names?

Marc