How to Bind a GridView Control to XML in ASP.NET

In this example, your XML content is assumed to be ready and well formatted. To be compatible with a GridView, the XML document has to have a database-like format (table and records):




ANGOLA241345 amp


BENIN204435 amp



1. Drag a GridView component from the Toolbox.
2. Add to your GridView a PreRender event.
3. Write your code (see below) to bind a DataSet to the GridView.


public partial class _Default : System.Web.UI.Page
{
protected void MyGridView_PreRender(object sender, EventArgs e)
{
// Creates a DataSet and loads it with an Xml Content
DataSet aDataSet = new DataSet();
aDataSet.ReadXml(new StringReader(aXmlDoc.OuterXml));

// Bind the DataSet to the grid view
GridView gv = (GridView)sender;
gv.DataSource = aDataSet;
gv.DataBind();
}
}