C# UI to XML Data Storage

C# UI to XML Data Storage

<div>

        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><asp:TextBox ID="TextBox3"

            runat="server"></asp:TextBox><asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>

        <asp:Button ID="Button1" runat="server" Text="Insert  Data" Height="25px"

            onclick="Button1_Click" Width="80px" />

        <asp:Button ID="Button2" runat="server" Height="28px" onclick="Button2_Click"

            Text="Show Data" Width="80px" />

        <asp:Button ID="Button3" runat="server" onclick="Button3_Click"

            Text="Show XML" />

    </div>

    <asp:GridView ID="GridView1" runat="server">

    </asp:GridView>

using System.Data.SqlClient;

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

    {

        static DataSet ds;

        static DataTable dt;

        static DataRow dr;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                ds = new DataSet();

                ds.ReadXml(Server.MapPath("~/Videos.xml"));

                dt = ds.Tables["Product"];

            }

        }

        void clear()

        {

            TextBox1.Text = "";

            TextBox2.Text = "";

            TextBox3.Text = "";

            TextBox4.Text = "";

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            dr = dt.NewRow();

            dr["ProductId"] = TextBox1.Text;

            dr["Name"] = TextBox2.Text;

            dr["SmallImagePath"] = TextBox3.Text;

            dr["SmallDescreption"] = TextBox4.Text;

            dt.Rows.Add(dr);

            ds.WriteXml(Server.MapPath("~/Videos.xml"));

            Response.Write("Record Successfully Inserted");

            clear();

        }

        protected void Button2_Click(object sender, EventArgs e)

        {

            DataSet ds = new DataSet();

            ds.ReadXml(Server.MapPath("~/Videos.xml"));

            GridView1.DataSource = ds;

            GridView1.DataBind();

        }

        protected void Button3_Click(object sender, EventArgs e)

        {

            Response.Redirect("~/Videos.xml");

        }

       protected void BtnRemove_Click(object sender, EventArgs e)

        {

         //   Response.Redirect("~/Videos.xml");

            XmlDocument xmlDoc = new XmlDocument();

            xmlDoc.Load(Server.MapPath("~/Videos.xml"));

            XmlNode node = xmlDoc. SelectSingleNode     ("//NewDataSet//Product[ProductID=1]");

            node.ParentNode.RemoveChild(node);

            xmlDoc.Save(Server.MapPath("~/Videos.xml"));

        }

    }

//Create Xml Like This Format

<NewDataSet>

  <Product>

    <ProductID>1</ProductID>

    <Name>Trifla</Name>

    <SmallImagePath>medohar</SmallImagePath>

    <SmallDescreption>medohar.jpg</SmallDescreption>

  </Product>

</NewDataSet>