How to create an XML file in VB.NET using Dataset

In the previous section, we utilized the XmlTextWriter class to create an XML file. Now, we will explore another approach for generating an XML file named Product.XML using an ADO.NET Dataset. To accomplish this, we need to follow a series of steps.


Firstly, we manually create a DataTable that corresponds to the structure of the Product.XML file. This DataTable serves as a container to hold the data for the XML file. We populate this DataTable with the necessary data from various sources.

Once the DataTable is populated, we proceed to create a Dataset, which acts as a container for one or more DataTables. We add our previously created DataTable to this Dataset.

WriteXml method

To generate the XML file, we call the WriteXml method of the Dataset, providing the file name "Product.XML" as an argument. This method automatically writes the contents of the Dataset, including the DataTable and its data, to the specified XML file.

Full Source VB.NET
Imports System.Xml Imports System.Data Public Class Form1 Dim dt As DataTable Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New DataSet dt = New DataTable() dt.Columns.Add(New DataColumn("Product_ID", Type.GetType("System.Int32"))) dt.Columns.Add(New DataColumn("Product_Name", Type.GetType("System.String"))) dt.Columns.Add(New DataColumn("product_Price", Type.GetType("System.Int32"))) fillRows(1, "product1", 1111) fillRows(2, "product2", 2222) fillRows(3, "product3", 3333) fillRows(4, "product4", 4444) ds.Tables.Add(dt) ds.Tables(0).TableName = "product" ds.WriteXml("Product.xml") MsgBox("Done") End Sub Private Sub fillRows(ByVal pID As Integer, ByVal pName As String, ByVal pPrice As Integer) Dim dr As DataRow dr = dt.NewRow() dr("Product_ID") = pID dr("Product_Name") = pName dr("product_Price") = pPrice dt.Rows.Add(dr) End Sub End Class

It's important to note that this process allows for customization and manipulation of the data before writing it to the XML file. Additionally, the ADO.NET Dataset provides various options and overloads for the WriteXml method, enabling control over the XML file's structure, formatting, and other parameters.


By creating a DataTable, populating it with data, incorporating it into a Dataset, and utilizing the WriteXml method, we can effortlessly generate an XML file in VB.NET. This approach utilizes the capabilities of ADO.NET to streamline the process of creating XML files from structured data.