Summary How to bind a XML to a DataGrid?

A datagrid is a very powerful control to hold data. It can hold data from any type of source. In this example I will show you how you can bind a XML file to a datagrid control. I assume that you have a beginner knowledge to include a datagrid via Visual Studio .NET. I will bind the following XML file to the datagrid.  

Additional information

private void Page_Load(object sender, System.EventArgs e) { // Create a new dataset object DataSet ds = new DataSet(); // read the xml file ds.ReadXml(Server.MapPath("Topxml.xml")); // Set the datasource of the Datagrid // with the dataset dg.DataSource = ds; // bound the datagrid dg.DataBind(); } Now in the design view of your page your datagrid should look like this: design.aspx(design view): <asp:DataGrid id="dg" runat="server" AutoGenerateColumns="False" Width="360px"> <Columns> <asp:BoundColumn DataField="Description" HeaderText="Description"></asp:BoundColumn> <asp:BoundColumn DataField="Active" HeaderText="Active"></asp:BoundColumn> </Columns> </asp:DataGrid>

Further additional information

<?xml version="1.0" encoding="utf-8"?> <CategoryList> <Category> <MainCategory ID="01">VC++</MainCategory> <Description>VC++ Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="02">XML</MainCategory> <Description>XML Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="03">XSL</MainCategory> <Description>XSL Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="04">XPath</MainCategory> <Description>XPath Articles</Description> <Active>Yes</Active> </Category> <Category> <MainCategory ID="05">XQuery</MainCategory> <Description>XQuery Articles</Description> <Active>Yes</Active> </Category> </CategoryList>

---

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote : 1 2 3 4 5 6 7 8 9 10  

Updating...

<< System.XML		.NET and XML (67)Ajax (2)BizTalk (55)CSS (114)JavaScript (64)LAMP (6)Microsoft ASP (90)PHP XML (89)reBlogger (0)Schemas, xsd, xdr (45)SEO (3)SQL XML (76)System.XML (39)Uncategorized (137)WCF, WS, SOAP (55)XALAN (22)XHTML (97)XML DOM (119)XmlSerializer (34)XQuery (24)XSLT (252)	WCF, WS, SOAP >>

Updating comments...

---

Updating comments...

Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown: