ASP.NET(vb.net) & DataGrid - XML

Author: admin | Posted: 06-06-2010 | Category: ASP.NET(vb.net) & DataGrid Control

ASP.NET(vb.net) & DataGrid - XML Example scripts how to Explains DataGrid control in asp.net , Binding the datasource (XML) to DataGrid control.

ShotDev Focus:
- ASP.NET(vb.net) & DataGrid - XML

customer.xml


<?xml version="1.0" encoding="UTF-8"?>
<mydatabase>
<customer>
<CustomerID>C001</CustomerID>
<Name>Win Weerachai</Name>
<Email>win.weerachai@shotdev.com</Email>
<CountryCode>TH</CountryCode>
<Budget>1000000</Budget>
<Used>600000</Used>
</customer>
<customer>
<CustomerID>C002</CustomerID>
<Name>Jake Sully</Name>
<Email>jake.sully@shotdev.com</Email>
<CountryCode>EN</CountryCode>
<Budget>2000000</Budget>
<Used>800000</Used>
</customer>
<customer>
<CustomerID>C003</CustomerID>
<Name>Tony Stark</Name>
<Email>tony.stark@shotdev.com</Email>
<CountryCode>US</CountryCode>
<Budget>3000000</Budget>
<Used>600000</Used>
</customer>
<customer>
<CustomerID>C004</CustomerID>
<Name>Peter Parker</Name>
<Email>peter.parker@shotdev.com</Email>
<CountryCode>US</CountryCode>
<Budget>4000000</Budget>
<Used>100000</Used>
</customer>
</mydatabase>

Example

DataGridReadXml.aspx


<%@ Import Namespace="System.Data"%>
<%@ Page Language="VB" %>
<script runat="server">

Sub Page_Load(sender As Object, e As EventArgs)
Dim ds As New DataSet
ds.ReadXml(MapPath("customer.xml"))

'*** BindData to DataGrid ***'
myDataGrid.DataSource = ds
myDataGrid.DataBind()

End Sub

</script>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<form id="form1" runat="server">
<asp:DataGrid id="myDataGrid" runat="server">
</asp:DataGrid>
</form>
</body>
</html>

Create a asp.net file and save to path root-path/dotnet/

Run
http://localhost/dotnet/DataGridReadXml.aspx

Screenshot

.
.
.