how to convert xml file to gridview

See more:

XML

Hi,

I have a sample XML file. From this I want to convert this file into gridview and then into csv format. I got success from xml to grid view. But I can't get into csv format. In csv it is displaying only id numbers from 1 to 11. So please clear my doubt. Below I send my xml file and codebehind file for your verification. Please clear my doubt.

//sample xml//

<employee>
  
    <id>1</id>
    <name>Florian</name>
    <phone>123</phone>
  
  
    <id>2</id>
    <name>Andreas</name>
    <phone>234</phone>
  
  
    <id>3</id>
    <name>Martin</name>
    <phone>345</phone>
  
  
    <id>4</id>
    <name>jacobs</name>
    <phone>111</phone>
  
  
    <id>5</id>
    <name>Ricky</name>
    <phone>222</phone>
  
  
    <id>6</id>
    <name>michael</name>
    <phone>333</phone>
  
  
    <id>7</id>
    <name>vauchan</name>
    <phone>444</phone>
  
  
    <id>8</id>
    <name>shane</name>
    <phone>555</phone>
  
  
    <id>9</id>
    <name>watson</name>
    <phone>666</phone>
  
  
    <id>10</id>
    <name>Marsh</name>
    <phone>777</phone>
  
</employee>

//below is the code behind file///

protected void Page_Load(object sender, EventArgs e)
    {
         

            DataSet ds=new DataSet();
        ds.ReadXml( "C:/Documents and Settings/sridharan/Desktop/sridharan/004_xml_gridview/XMLFile.xml");
        GridView1.DataSource =ds;
        GridView1.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        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();
    }