GridView Data Binding to XML in C#.NET

The Kettic DataGridView Control is able to be bound to any XML, custom business object and web service directly in Windows Forms development environments. The data binding operation only need the data objects implement one of these interfaces, IList, IEnumarable, or ICollection. Additionally, the powerful DataGridView control supports out of the box binding to objects in sub directory as well as their properties for customizing.

The Kettic DataGridView Control does not support the data binding to XML directly, but accomplish data binding to XML through DataTables. Users of the Kettic DataGridView component are able to create DataSet and DataTables from an XML document. The following is a XML file used in data binding for GridView control.

<?xml version="1.0" encoding="utf-8"?>
<people>
  <person>
    <name> Simon </name>
    <age> 35 </age>
  </person>
  <person>
    <name> Matt </name>
    <age> 32 </age>
  </person>
  <person>
    <name> David </name>
    <age> 31 </age>
  </person>
</people>

To bind GridView component to XML, we need to create a DataSet instance from the xml file first. In the example of the XML file above, there is only a single DataTable which is set as the data source of Kettic GridView control. It is also possible to bind GridView to hierarchy data of XML file, which is available on binding to hierarchy data. The following are the C# code used to bind GridView component to XML file.

DataSet xmlDataSet = new DataSet();
xmlDataSet.ReadXml("..\\KetticGridViewWinForms\\DataSamples\\PopulatingWithData\\gridXml.xml");
this.ketticGridView1.DataSource = xmlDataSet.Tables[0];