export datagridview to xml

hi dear ;
At firstly I am fill to datagrid manually and save as Xml ,folowing this code,But if I fill to multiple rows in datagrid and then only export last rows

for (int i = 0; i < dataGridView1.Rows.Count; i++)

{

XmlTextWriter xmlDocument = new XmlTextWriter(@"d:\Deneme.xml", System.Text.Encoding.GetEncoding("ISO-8859-9"));

xmlDocument.Formatting = Formatting.Indented;

xmlDocument.Indentation = 5;

try

{

xmlDocument.WriteStartDocument();

xmlDocument.WriteStartElement("SALES_INVOICES");

xmlDocument.WriteElementString("TYPE", dataGridView1.Rows[i].Cells[0].Value.ToString());

xmlDocument.WriteEndElement();

xmlDocument.Close();

MessageBox.Show("Xml Created.");

}

catch (Exception ex)

{

MessageBox.Show("Hata" + ex.Message);

}

}

And Result is

1453

I want to result is ;

1452

1453

Thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Umesh Kumar12y ago
You can get the datasource of the grid to a dataset and use the code above
Demir Acar12y ago
I fill to datagrid from excel or enter data manually ..
Umesh Kumar12y ago
If u are using dataset to bind
Use Below Code
```
ds.WriteXml("d:\\employee.xml");  
```