Create Dataset From XML

.NET and XML Web Services

Home

Web Services

XML

Schema

XSLT

Serialize

Database

XQuery

ASP

Contact

Site Map

Home

Web Services

XML in .NET

XML Schema

XSLT and XPath

XML Serialization

Database and XML

SOAP Related

XML Query

ASP.NET

Contact Info

.NET Notes

Sample Program Code:

Dim ds As DataSet = New DataSet()

ds.ReadXml(Server.MapPath("people.xml"))

With DataGrid1

.DataSource = ds

.DataMember = "name" .

DataBind()

End With

Please visit our Partner....

Create A Dataset From An XML File

The Name Dataset loaded in the following grid was created from the People XML file shown in the textbox below.

FirstName	LastName	Person_Id
Joe	Suits	0
Linda	Sue	1
Jeremy	Boards	2
Joan	Page	3

<People> <Person> <Name> <FirstName>Joe</FirstName> <LastName>Suits</LastName> </Name> <Address> <Street>1800 Success Way</Street> <City>Redmond</City> <State>WA</State> <ZipCode>98052</ZipCode> </Address> <Job> <Title>CEO</Title> <Description>Wears the nice suit</Description> </Job> </Person> <Person> <Name> <FirstName>Linda</FirstName> <LastName>Sue</LastName> </Name> <Address> <Street>1302 American St.</Street> <City>Paso Robles</City> <State>CA</State> <ZipCode>93447</ZipCode> </Address> <Job> <Title>Attorney</Title> <Description>Stands up for justice</Description> </Job> </Person> <Person> <Name> <FirstName>Jeremy</FirstName> <LastName>Boards</LastName> </Name> <Address> <Street>34 Palm Avenue</Street> <City>Waikiki</City> <State>HI</State> <ZipCode>98052</ZipCode> </Address> <Job> <Title>Pro Surfer</Title> <Description>Rides the big waves</Description> </Job> </Person> <Person> <Name> <FirstName>Joan</FirstName> <LastName>Page</LastName> </Name> <Address> <Street>700 Webmaster Road</Street> <City>Redmond</City> <State>WA</State> <ZipCode>98073</ZipCode> </Address> <Job> <Title>Web Site Developer</Title> <Description>Writes the pretty pages</Description> </Job> </Person> </People>