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(); }
<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>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)