Save DataSet as XML File - Visual Basic , VB.NET

	Find Code:
Home : Code : Forums : Submit : Mailing List : About : Contact

All

VB.NET

ASP.NET

C#

Snippets

Popular

Forums

Articles

Tips

Links

Books

Contest

Save DataSet as XML File
Author: KBailey
Submitted: 9/27/2003
Version: VB.NET 2002
Compatibility: VB.NET
Category: XML
Views: 88573
This code shows how to save the contents of a DataSet as an XML File.
Declarations:
'none
Code:
Private Sub btnWriteXMLData_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles btnWriteXMLData.Click Dim dsSales As New DataSet() Dim cn As New SqlConnection _ ("data source=localhost;initial catalog=pubs;user id=sa") Dim daAuthors As New SqlDataAdapter("select * from sales ", cn) Dim daPublishers As New SqlDataAdapter("select * from stores ", cn) ' Load data from database daAuthors.Fill(dsSales, "Sales") daPublishers.Fill(dsSales, "Stores") ' Write XML to file dsSales.WriteXml("XMLFile.xml") End Sub