How to save XML data into database

Imports System.Xml
Imports System.Data.SqlClient
Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim connetionString As String
        Dim connection As SqlConnection
        Dim command As SqlCommand
        Dim adpter As New SqlDataAdapter
        Dim ds As New DataSet
        Dim xmlFile As XmlReader
        Dim sql As String
        Dim product_ID As Integer
        Dim Product_Name As String
        Dim product_Price As Double
        connetionString = "Data Source=servername;Initial Catalog=databsename;User ID=username;Password=password"
        connection = New SqlConnection(connetionString)
        xmlFile = XmlReader.Create("Product.xml", New XmlReaderSettings())
        ds.ReadXml(xmlFile)
        Dim i As Integer
        connection.Open()
        For i = 0 To ds.Tables(0).Rows.Count - 1
            product_ID = Convert.ToInt32(ds.Tables(0).Rows(i).Item(0))
            Product_Name = ds.Tables(0).Rows(i).Item(1)
            product_Price = Convert.ToDouble(ds.Tables(0).Rows(i).Item(2))
            sql = "insert into Product values(" & product_ID & ",'" & Product_Name & "'," & product_Price & ")"
            command = New SqlCommand(sql, connection)
            adpter.InsertCommand = command
            adpter.InsertCommand.ExecuteNonQuery()
        Next
        connection.Close()
    End Sub
End Class

How to insert elements into XML File

using System.Xml;

public partial class index : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        // Open the XML doc

            

        System.Xml.XmlDocument myXmlDocument = new System.Xml.XmlDocument();

        myXmlDocument.Load(Server.MapPath("books.xml"));

        System.Xml.XmlNode myXmlNode = myXmlDocument.DocumentElement.FirstChild;

        // Create new XML element and populate its attributes

        System.Xml.XmlElement myXmlElement = myXmlDocument.CreateElement("entry");

        XmlElement name = myXmlDocument.CreateElement("Name");

        name.InnerText = Server.HtmlEncode(TextBoxName.Text).ToString();

        myXmlElement.AppendChild(name);

        XmlElement location=myXmlDocument.CreateElement("Location");

        location.InnerText=Server.HtmlEncode(TextBoxLocation.Text).ToString();

        myXmlElement.AppendChild(location);

        XmlElement email=myXmlDocument.CreateElement("Email");

        email.InnerText=Server.HtmlEncode(TextBoxEmail.Text).ToString();

        myXmlElement.AppendChild(email);

        XmlElement gender = myXmlDocument.CreateElement("Gender");

        gender.InnerText=Server.HtmlEncode(DropDownListGender.SelectedItem.Text).ToString();

        myXmlElement.AppendChild(gender);

        // Insert data into the XML doc and save

        myXmlDocument.DocumentElement.InsertBefore(myXmlElement, myXmlNode);

        myXmlDocument.Save(Server.MapPath("books.xml"));

        // Re-bind data since the doc has been added to

        BindData();

        LabelMessage.Text = "Record inserted Successfully Inside the XML File...";

        TextBoxName.Text = "";

        TextBoxLocation.Text = "";

        TextBoxEmail.Text = "";

    }

    void BindData()

    {

        XmlTextReader myXmlReader = new XmlTextReader(Server.MapPath("books.xml"));

        myXmlReader.Close();

    }

}