How to perform edit and delete data from html table row as well as from xml file in the following code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Text" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.IO" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
<html xmlns="http://www.w3.org/1999/xhtml"&gt;
<head runat="server">
    <title>Untitled Page</title>

    <script type="text/javascript" language="javascript">
    if (window.XMLHttpRequest)
  {
  xhttp=new XMLHttpRequest();
  }
else // Internet Explorer 5/6
  {
  xhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xhttp.open("GET","material.xml",false);
xhttp.send("");
xmlDoc=xhttp.responseXML;


document.write("<table border='1' id='tid' cellspacing='4' cellpadding='4'>");
document.write("<form name='form1'");
document.write("<tr><td>MATERIALNAME</td><td>MATERIALTYPE</td><td>QUANTITY</td><td>UOM</td></tr>");
var x=xmlDoc.getElementsByTagName("Material");
for (i=0;i<x.length;i++)
  {
  document.write("<tr><td>");
  document.write(x[i].getElementsByTagName("MaterialType")[0].childNodes[0].nodeValue);
  document.write("</td><td>");
  document.write(x[i].getElementsByTagName("MaterialName")[0].childNodes[0].nodeValue);
  document.write("</td><td>");
 document.write(x[i].getElementsByTagName("Quantity")[0].childNodes[0].nodeValue);
 document.write("</td><td>");
document.write(x[i].getElementsByTagName("UOM")[0].childNodes[0].nodeValue);
document.write("</td><td>");
document.write("<input type='button' value='Edit' id='edit[]' onclick='test();'/>");
document.write("</td><td>");

  document.write("<input type='button' value='Delete' id='delete[]' onclick='deleteRow(this.parentNode.parentNode.rowIndex);'/>");

  document.write("</td></tr>");
  document.write("</form>");


  }
function deleteRow(t){
    document.getElementById('tid').deleteRow(t);


}





   </script>
    <script language="C#" runat="server">

        public void add_click(Object sender, EventArgs E)
        {

            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            DataRow dr = dt.NewRow();
            dt.Columns.Add("MaterialType");
            dt.Columns.Add("MaterialName");
            dt.Columns.Add("Quantity");
            dt.Columns.Add("UOM");
            dr[0] = Request.Form["mattype"].ToString();
            dr[1] = mname.Value.ToString();
            dr[2] = qname.Value.ToString();
            dr[3] = Request.Form["uom"].ToString();
            dt.Rows.Add(dr);
            ds.Tables.Add(dt);
            if (!File.Exists(@"D:\purchase\material.xml"))
            {
                ds.Tables[0].WriteXml(@"D:\purchase\material.xml", XmlWriteMode.IgnoreSchema);
                return;
            }


            XmlDocument xmlDoc = new XmlDocument();

            xmlDoc.Load(@"D:\purchase\material.xml");

            XmlElement subRoot = xmlDoc.CreateElement("Material");
            //subRoot.SetAttribute("ID", "01");


            //MaterialType

            XmlElement appendedElementMaterialType = xmlDoc.CreateElement("MaterialType");

            XmlText xmlTextMaterialType = xmlDoc.CreateTextNode(dr[0].ToString());

            appendedElementMaterialType.AppendChild(xmlTextMaterialType);

            subRoot.AppendChild(appendedElementMaterialType);

            xmlDoc.DocumentElement.AppendChild(subRoot);

            //MaterialName


            XmlElement appendedElementMaterialName = xmlDoc.CreateElement("MaterialName");

            XmlText xmlTextMaterialName = xmlDoc.CreateTextNode(dr[1].ToString());

            appendedElementMaterialName.AppendChild(xmlTextMaterialName);

            subRoot.AppendChild(appendedElementMaterialName);

            xmlDoc.DocumentElement.AppendChild(subRoot);

            //Quantity

            XmlElement appendedElementQuantity = xmlDoc.CreateElement("Quantity");

            XmlText xmlTextQuantity = xmlDoc.CreateTextNode(dr[2].ToString());

            appendedElementQuantity.AppendChild(xmlTextQuantity);

            subRoot.AppendChild(appendedElementQuantity);

            xmlDoc.DocumentElement.AppendChild(subRoot);

            //UOM

            XmlElement appendedElementUOM = xmlDoc.CreateElement("UOM");

            XmlText xmlTextUOM = xmlDoc.CreateTextNode(dr[3].ToString());

            appendedElementUOM.AppendChild(xmlTextUOM);

            subRoot.AppendChild(appendedElementUOM);

            xmlDoc.DocumentElement.AppendChild(subRoot);

            xmlDoc.Save(@"D:\purchase\material.xml");


        }
        public void del_click(Object sender, EventArgs e)
        {
            mattype.Value.Equals(null);
            mname.Value.Equals(null);
            qname.Value.Equals(null);
            uom.Value.Equals(null);

        }     




    </script>

</head>
<body>
    <form id="form1" action="" method="post" runat="server">
    <div>
        <fieldset>
            <center>
                <table border="1" cellpadding="0" cellspacing="4">
                    <tr>
                        <td colspan="2">
                            <h1>
                                <b>create new material</b></h1>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <b>MATERIAL TYPE:</b>
                        </td>
                        <td>
                            <select id="mattype" runat="server">
                                <option>----select----</option>
                                <option>stationary</option>
                                <option>cloth</option>
                                <option>machines</option>
                            </select><br />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <b>MATERIAL NAME:</b>
                        </td>
                        <td>
                            <input type="text" id="mname" size="30" runat="server" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <b>QUANTITY :</b>
                        </td>
                        <td>
                            <input type="text" id="qname" size="30" runat="server" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <b>UOM</b>
                        </td>
                        <td>
                            <select id="uom" runat="server">
                                <option value="">----select----</option>
                                <option>Number</option>
                                <option>Packet</option>
                                <option>kg</option>
                            </select><br />
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2">
                            <input id="Submit1" type="submit" value="save" onclick="return Submit_OnClick()"
                                onserverclick="add_click" runat="server" />
                            <input id="Reset1" type="reset" value="cancel" onclick="return reset_OnClick()" onserverclick="del_click" runat="server" />
                        </td>
                    </tr>
                </table>
            </center>
        </fieldset>
    </div>
    </form>
</body>
</html>
ansaurus

tags:

views:

answers:

How to perform edit and delete data from html table row as well as from xml file in the following code

related questions
