Get DataTable from DataGridView
DataTable dt = new DataTable();
dt = (DataTable)dataGridView1.DataSource;
DataSet support the transition to XML, so we will move DataTable above to a DataSet
DataSet ds = new DataSet();
ds.Tables.Add(dt);
Export DataSet to XML
ds.WriteXml("D:\\Customers.xml", System.Data.XmlWriteMode.IgnoreSchema);
Complete Source Code
private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = _customers.GetCustomers();
dataGridView1.DataSource = dt;
}
private void btnExportXML_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = (DataTable)dataGridView1.DataSource;
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXml("D:\\Customers.xml", System.Data.XmlWriteMode.IgnoreSchema);
}
Related posts:
No Comments