Export DataGridView to XML - C#

I have a DataGridView in my application with values from a database table. I also have functions that filter the data in the gridview.

I want to know if its possible to save the filtered data in 开发者_运维技巧the gridview in an XML file.

How would I do this?

Thanks.

---

If your datatables datasource is a DataTable then

table.DefaultView

contains a subset of your data that reflects the current sorting / filtering

var table = dataGridView1.DataSource as DataTable;
var view = table.DefaultView;

this view can be saved as XML, too

view.ToTable().WriteXml(@"c:\view.xml");

---

Have you tried DataTable.WriteXml()?

---

Are you sure that your datagridview is using datatable as the source? It looks like you are using some different object such as dataset as source. Try

DataSet ds = new DataSet();

ds = (DataSet)datagridview.DataSource;

ds.Tables[0].WriteXml(xml_file, System.Data.XmlWriteMode.IgnoreSchema);