Update and insert XML Element with DataSet : 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 
Update and insert XML Element with DataSet

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")
        MyDS.ReadXml("book.xml")

        MyDS.AcceptChanges()

        Dim NewBook As DataRow = MyDS.Tables("Book").NewRow()
        NewBook("Title""This ADO.NET Book"
        MyDS.Tables("Book").Rows.Add(NewBook)

        MyDS.WriteXml("Books_Changes.xml", XmlWriteMode.DiffGram)

        MyDS.AcceptChanges()
        MyDS.WriteXml("Books_New.xml", XmlWriteMode.IgnoreSchema)

    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.Read XML schema with DataSet and output its structureRead XML schema with DataSet and output its structure
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.