Skip to Content
Visual Basic® .NET by Example
book

Visual Basic® .NET by Example

by Gabriel Oancea, Bob Donald
December 2001
Beginner
976 pages
22h 4m
English
Que
Content preview from Visual Basic® .NET by Example

Reading XML and XML Schema into a DataSet

In addition to loading a DataSet from records in a database, you can also construct a DataSet and populate it using a defined XML Schema and content defined in an XML file. This allows you to load XML data and work with it as a DataSet. Here is an example Console application project that loads a DataSet from XML:

Imports System.Data.SqlClient
Imports System.Data.Common
Module Module1

    Sub Main()

        Dim ds As DataSet = New DataSet()

        Try

            ds.ReadXmlSchema("Authors.xsd")
            ds.ReadXml("Authors.xml")

            Console.WriteLine(ds.GetXmlSchema())
            Console.WriteLine(ds.GetXml())

        Catch ex As SqlException
            Console.WriteLine(ex.Message)
        End Try

    End Sub

End Module

Note

In order to read these files, they must be in the “bin” folder ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Application Development Using Visual Basic® and .NET

Application Development Using Visual Basic® and .NET

Robert J. Oberg, Peter Thorsteinson, Dana L. Wyatt

Publisher Resources

ISBN: 0789725835Purchase book