Expertrating - ASP.Net Tutorial, Working with XML

Home > Courses, Tutorials & eBooks > ASP.NET Tutorial > Working with XML

ASP.NET Tutorial - Working with XML

Page 3 of 3

Example59: ReadSchemaFile.aspx

<%@ Import Namespace="System.Data" %>

Sub Page_Load

Dim dstMenu As DataSet

dstMenu = New DataSet ()

dstMenu.ReadXml( MapPath( "SchemaFile.xml" ) )

rptItems.DataSource = dstMenu

rptItems.DataBind ()

End Sub

</Script>

<html>

<head><title>ReadSchemaFile.aspx</title></head>

<body>

<asp: Repeater

ID="rptItems"

Runat="Server" >

<hr>

<p><b>Items:</b>

<p><b>Price:</b>

<p><b>Price Data Type:</b>

</ItemTemplate>

</asp:Repeater>

</body>

</html>

The output is shown below: -

In the subroutine above, the ReadXml () method retrieves the SchemaFile.xml file into DataSet. The DataSet is then bound to a Repeater control, which displays the values of all the elements by using Repeaters.

Writing an XML Document from a DataSet

The DataSet classes include several methods for retrieving an XML representation of the data contained in a DataSet. If a string representation of XML data is to be retrieved the GetXml () method can be used as shown in the following example:-

Example60: GetMyXml.aspx

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.SqlClient" %>

Sub Page_Load

Dim conNorthwind As SqlConnection

Dim dadEmployees As SqlDataAdapter

Dim dstEmployees As DataSet

Dim strXmlData As String

conNorthwind = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;Database=Northwind" )

dadEmployees = New SqlDataAdapter( "Select * From Employees", conNorthwind )

dstEmployees = New DataSet()

dadEmployees.Fill ( dstEmployees, "Employees" )

strXmlData = dstEmployees.GetXml()

Response.Write( "<pre>" & Server.HtmlEncode( strXmlData ) & "</pre>" )

End Sub

</Script>

The output is shown below: -

In the above example, the DataSet is dealing with Employees table of Northwind database of SqlServer. After employees table is added to the DataSet, the GetXml () method retrieves a string that contains an XML representation of the DataSet. This string is assigned to a variable named strXmlData and output is obtained using the Response object.

ExpertRating ASP.NET Certification - Get Certified Now!!