ASP.NET

<br />
 private string getXmlTagDate(XmlElement xEle, string name)<br />
    {<br />
        XmlNodeList xList;<br />
        string text;<br />
        xList = xEle.GetElementsByTagName(name);<br />
        if (xList.Count > 0)<br />
        {<br />
            text = xList[0].InnerText.ToString();<br />
            text = Convert.ToDateTime(text).ToShortDateString();<br />
        }<br />
        else<br />
        {<br />
            text = "00/00/0000";<br />
        }<br />
        return text;<br />
    }<br />
<br />

<br />
<br />
<?xml version="1.0" standalone="yes"?><br />
<NewDataSet><br />
  <PinType_TABLE><br />
    <pinname>HALF UNIT</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>50</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>6000</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-02-01T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
  <PinType_TABLE><br />
    <pinname>Full</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>100</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>12000</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-02-03T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
  <PinType_TABLE><br />
    <pinname>fourth unit</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>25</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>3000</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-05-21T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
  <PinType_TABLE><br />
    <pinname>s.s</pinname><br />
    <fullvalue>12000</fullvalue><br />
    <percent_value>0</percent_value><br />
    <pin_type>P</pin_type><br />
    <pin_price>0</pin_price><br />
    <ind_active>1</ind_active><br />
    <CreateOn>2009-07-16T00:00:00+05:30</CreateOn><br />
  </PinType_TABLE><br />
</NewDataSet><br />
<br />

protected void Button2_Click(object sender, EventArgs e)
    {
        OleDbDataReader dr = null;
        string str = "Select Count(Specification)From ProductSpecification";
        OleDbCommand cmd = new OleDbCommand(str, conn);
        conn.Open();
        string Count = cmd.ExecuteScalar().ToString();
        int count = Convert.ToInt32(Count);
        conn.Close();
        str = "Select * From ProductSpecification";
        cmd = new OleDbCommand(str, conn);
        conn.Open();
       // dr = cmd.ExecuteReader();
        //DataTable dt = new DataTable();
       // dt.Load(dr);
        
        for (int i = 1; i <= count; i++)
        {
            txt = new TextBox[count]; 
            //string s=dr["Specification"].ToString();
            //TextBox text = (TextBox)Panel2.FindControl(txt[i].ID);
            ///TextBox txtctrl = (TextBox)Panel2.FindControl("txt" + i.ToString());
            txt[i] = new TextBox(); 
            txt[i].ID = "txt" + i.ToString();
            string s1 = txt[i].Text;
            string s2 = "Insert Into ProductSpecification(Value)Values('"+s1+"')";
            cmd = new OleDbCommand(s2, conn);
            cmd.ExecuteNonQuery();
           
        }
        conn.Close();
    }