XML to csv conversion

See more:

XML

Hai,


I am having web application for converting xml to csv.I put One button in my application.If I click that button xml files should be converted into csv.I tried it by using code.But the final output didnot match the xml.Below is my code.Please refer this and give me a idea for how to solve this.

//aspx.cs page

protected void Button1_Click(object sender, EventArgs e)
   {
       DataSet ds = new DataSet();
       ds.ReadXml("C:/Documents and Settings/sridharan/Desktop/sridharan/exporting xml values into excel or csv/products.xml");
       Response.Clear();
       Response.Buffer = true;
       Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.csv");
       Response.Charset = "";
       Response.ContentType = "application/text";

       GridView1.AllowPaging = false;
       GridView1.DataBind();

       StringBuilder sb = new StringBuilder();
       for (int k = 0; k < GridView1.Columns.Count; k++)
       {
           //add separator
           sb.Append(GridView1.Columns[k].HeaderText + ',');
       }
       //append new line
       sb.Append("\r\n");
       for (int i = 0; i < GridView1.Rows.Count; i++)
       {
           for (int k = 0; k < GridView1.Columns.Count; k++)
           {
               //add separator
               sb.Append(GridView1.Rows[i].Cells[k].Text + ',');
           }
           //append new line
           sb.Append("\r\n");
       }
       Response.Output.Write(sb.ToString());
       Response.Flush();
       Response.End();
   }

//xml

<employee>
  
    <id>id</id>
    <name>name</name>
    <phone>phone</phone>
    <address>address</address>
    <age>age</age>
    <dateofbirth>dateofbirth</dateofbirth>
    <company>company</company>
  
  
    <id>1</id>
    <name>Florian</name>
    <phone>123</phone>
    <address>mumbai</address>
    <age>32</age>
    <dateofbirth>8.8.78</dateofbirth>
    <company>skysoft</company>
  
  
    <id>2</id>
    <name>Andreas</name>
    <phone>234</phone>
    <address>bengaluru</address>
    <age>21</age>
    <dateofbirth>7.7.85</dateofbirth>
    <company>Infotechsolutions</company>
  
  
    <id>3</id>
    <name>Martin</name>
    <phone>345</phone>
    <address>hyderabad</address>
    <age>47</age>
    <dateofbirth>29.3.87</dateofbirth>
    <company>vayana</company>
  
  
    <id>4</id>
    <name>jacobs</name>
    <phone>111</phone>
    <address>kolkatta</address>
    <age>22</age>
    <dateofbirth>2.2.88</dateofbirth>
    <company>brainmagic</company>
  
  
    <id>5</id>
    <name>Ricky</name>
    <phone>222</phone>
    <address>trichy</address>
    <age>55</age>
    <dateofbirth>4.6.99</dateofbirth>
    <company>Infosys</company>
  
  
    <id>6</id>
    <name>michael</name>
    <phone>333</phone>
    <address>chennai</address>
    <age>28</age>
    <dateofbirth>31.7.91</dateofbirth>
    <company>Photon</company>
  
  
    <id>7</id>
    <name>vauchan</name>
    <phone>444</phone>
    <address>chennai</address>
    <age>55</age>
    <dateofbirth>5.5.77</dateofbirth>
    <company>OFS</company>
  
  
    <id>8</id>
    <name>shane</name>
    <phone>555</phone>
    <address>chennai</address>
    <age>33</age>
    <dateofbirth>23.5.67</dateofbirth>
    <company>Sunsmart</company>
  
  
    <id>9</id>
    <name>watson</name>
    <phone>666</phone>
    <address>chennai</address>
    <age>44</age>
    <dateofbirth>18.9.85</dateofbirth>
    <company>Ascendas</company>
  
  
    <id>10</id>
    <name>Marsh</name>
    <phone>777</phone>
    <address>chennai</address>
    <age>22</age>
    <dateofbirth>1.1.1</dateofbirth>
    <company>sap</company>
  
  
    <id>11</id>
    <name>sridharan</name>
    <phone>888</phone>
    <address>chennai</address>
    <age>31</age>
    <dateofbirth>22.4.66</dateofbirth>
    <company>Wipro</company>
  
  
    <id>12</id>
    <name>mishra</name>
    <phone>999</phone>
    <address>Delhi</address>
    <age>23</age>
    <dateofbirth>1.1.99</dateofbirth>
    <company>Infosys</company>
  
  
    <id>13</id>
    <name>vaibhav</name>
    <phone>1000</phone>
    <address>Ranchi</address>
    <age>22</age>
    <dateofbirth>11.2.98</dateofbirth>
    <company>TCS</company>
  
  
    <id>14</id>
    <name>Rajesh</name>
    <phone>1100</phone>
    <address>kochin</address>
    <age>11</age>
    <dateofbirth>29.3.78</dateofbirth>
    <company>CTS</company>
  
</employee>

Thanks in advance