This article shows how to create and sort the database in XML
format using datatable, dataset and datarow classes in Visual Studio 2010.
Insert the data in xml file
DataTable - represents a table in XML format in memory.It
manages data using Rows and Columns collections.
DataSource property are used to view the data in grid
format on the form.
To create a blank row use NewRow() method of DataTable
class and get reference of it using DataRow
NewRow().
Use DataSet class to read and write the
data on disc.
-
WriteXml(string filename)
-
ReadXml(string filename)
The dataset is a collection data table type
object. It manages Tables collections.
Open the visual studio and drag Two button named
(save and sort) three textbox and three level and one datagrid view controls on
the form. Form looks like this:
Figure 1.
Now add the following c# code:
using
System;
using
System.Collections.Generic;
using
System.ComponentModel;
using
System.Data;
using
System.Drawing;
using
System.Linq;
using
System.Text;
using
System.Windows.Forms;
using
System.IO;
using
System.Xml;
namespace
WindowsFormsApplication1
{
public partial class Form1 : Form
{
DataTable dt;
DataSet ds;
public Form1()
{
InitializeComponent();
}
private void
Form1_Load(object sender,
EventArgs e)
{
ds = new DataSet();
try
{
ds.ReadXml("F:/customer.xml");
dt = ds.Tables["Customer"];
}
catch (FileNotFoundException
ex)
{
dt = new
DataTable("Customer");
dt.Columns.Add("Cid");
dt.Columns.Add("Name");
dt.Columns.Add("Email");
ds.Tables.Add(dt);
}
dataGridView1.DataSource = dt;
}
private void
button1_Click(object sender,
EventArgs e)
{
DataRow dr = dt.NewRow();
dr[0] = txtCid.Text;
dr[1] = txtName.Text;
dr[2] = txtEmail.Text;
dt.Rows.Add(dr);
ds.WriteXml("F:/customer.xml");
MessageBox.Show("
Data has been saved");
txtCid.Clear();
txtEmail.Clear();
txtName.Clear();
}
private void
button2_Click(object sender,
EventArgs e)
{
XmlDataDocument xmlDatadoc =
new XmlDataDocument();
xmlDatadoc.DataSet .ReadXml("F:/customer.xml");
ds = xmlDatadoc.DataSet;
DataView dt =
ds.Tables[0].DefaultView;
dt.Sort = "cid ASC";
dataGridView1.DataSource = dt;
}
}
}
VB code:
Imports
System.Collections.Generic
Imports
System.ComponentModel
Imports
System.Data
Imports
System.Drawing
Imports
System.Linq
Imports
System.Text
Imports
System.Windows.Forms
Imports
System.IO
Imports
System.Xml
Namespace
WindowsFormsApplication1
Partial Public Class Form1
Inherits Form
Private dt As DataTable
Private ds As DataSet
Public Sub New()
InitializeComponent()
End Sub
Private Sub
Form1_Load(ByVal sender
As Object, ByVal
e As EventArgs)
ds = New
DataSet()
Try
ds.ReadXml("F:/customer.xml")
dt = ds.Tables("Customer")
Catch ex As FileNotFoundException
dt = New DataTable("Customer")
dt.Columns.Add("Cid")
dt.Columns.Add("Name")
dt.Columns.Add("Email")
ds.Tables.Add(dt)
End Try
dataGridView1.DataSource = dt
End Sub
Private Sub
button1_Click(ByVal sender
As Object,
ByVal e As EventArgs)
Dim dr As DataRow = dt.NewRow()
dr(0) = txtCid.Text
dr(1) = txtName.Text
dr(2) = txtEmail.Text
dt.Rows.Add(dr)
ds.WriteXml("F:/customer.xml")
MessageBox.Show("
Data has been saved")
txtCid.Clear()
txtEmail.Clear()
txtName.Clear()
End Sub
Private Sub
button2_Click(ByVal sender
As Object,
ByVal e As EventArgs)
Dim xmlDatadoc
As New XmlDataDocument()
xmlDatadoc.DataSet.ReadXml("F:/customer.xml")
ds = xmlDatadoc.DataSet
Dim dt As DataView = ds.Tables(0).DefaultView
dt.Sort = "cid ASC"
dataGridView1.DataSource = dt
End Sub
End Class
End Namespace
Now run the application and enter the cid value, name and email id and click on the button save record
will be save in the xml file and also display on the grid view.
Figure 2.
To sort the record according to cid click on the button sort.