C# - How Import and Export Data From XML File
In This C# Tutorial We Will See How To Export The DataGridView Values To A XML File Using CSharp Programming Language .
Source Code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Csharp_Datagridview_XML : Form
{
DataTable table = new DataTable("tbl");
public Csharp_Datagridview_XML()
{
InitializeComponent();
}
private void Csharp_Datagridview_XML_Load(object sender, EventArgs e)
{
table.Columns.Add("ID", typeof(int));
table.Columns.Add("First Name", typeof(string));
table.Columns.Add("Last Name", typeof(string));
table.Columns.Add("Age", typeof(int));
table.Rows.Add(1, "First A", "Last A", 10);
table.Rows.Add(2, "First B", "Last B", 20);
table.Rows.Add(3, "First C", "Last C", 30);
table.Rows.Add(4, "First D", "Last D", 40);
table.Rows.Add(5, "First E", "Last E", 50);
table.Rows.Add(6, "First F", "Last F", 60);
table.Rows.Add(7, "First G", "Last G", 70);
table.Rows.Add(8, "First H", "Last H", 80);
table.Rows.Add(9, "First I", "Last I", 90);
dataGridView1.DataSource = table;
}
private void BTN_EXPORT_Click(object sender, EventArgs e)
{
table.WriteXml(@"C:\Users\samsng\Documents\Visual Studio 2013\Projects\WindowsFormsApplication1\WindowsFormsApplication1\XMLFile1.xml",XmlWriteMode.WriteSchema);
MessageBox.Show("Data Exported");
}
private void BTN_IMPORT_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.ReadXml(@"C:\Users\samsng\Documents\Visual Studio 2013\Projects\WindowsFormsApplication1\WindowsFormsApplication1\XMLFile1.xml");
dataGridView2.DataSource = dt;
MessageBox.Show("Data Imported");
}
}
}
=> OutPut :
Download Projects Source Code
1 comments:
comments