Read XML schema with DataSet and output its structure : XML DataSet « XML « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Development
8.Event
9.File Directory
10.Generics
11.GUI
12.Language Basics
13.LINQ
14.Network Remote
15.Security
16.Thread
17.Windows Presentation Foundation
18.Windows System
19.XML
20.XML LINQ
VB.Net Tutorial
VB.Net by API
VB.Net » XML » XML DataSetScreenshots 
Read XML schema with DataSet and output its structure
Read XML schema with DataSet and output its structure

Imports System
Imports System.Xml
Imports System.Xml.Schema
Imports System.IO
Imports System.Collections
Imports System.Data


Public Class MainClass
    
    Shared Sub Main()
        Dim MyDS As New DataSet()
        MyDS.ReadXmlSchema("book.xdr")

        Console.WriteLine("Book Structure:")
        Dim Table As DataTable
        For Each Table In MyDS.Tables
            Console.WriteLine("Table {0}", Table.TableName)
            Dim Column As DataColumn
            For Each Column In Table.Columns
                Console.WriteLine("  {0}", Column.ColumnName)
            Next
        Next
    End Sub
End Class

'book.xdr
'<?xml version = "1.0"?>

'<Schema xmlns = "urn:schemas-microsoft-com:xml-data">
'   <ElementType name = "title" content = "textOnly" 
'      model = "closed" />

'   <ElementType name = "book" content = "eltOnly" model = "closed">
'      <element type = "title" minOccurs = "1" maxOccurs = "1" />
'   </ElementType>

'   <ElementType name = "books" content = "eltOnly" model = "closed">
'      <element type = "book" minOccurs = "0" maxOccurs = "*" />
'   </ElementType>
'</Schema>



           
       
Related examples in the same category
1.Update and insert XML Element with DataSet
2.Load xml document to DataSet
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.