Creatwe Xml To CSV

private string _Name = "export";
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/xmls/Indiatimes-46000.xml"));
ds.WriteXmlSchema(Server.MapPath("~/xmls/IndiaTimes.xsd"));
ExportCSV(ds.Tables[2]);
}

#region CSV

private void ExportCSV(DataTable _product)
{
DataTable dt = _product;
StringBuilder sb = new StringBuilder();

foreach (DataColumn col in dt.Columns)
{
sb.Append(col.ColumnName + ",");
}

sb.Remove(sb.Length - 1, 1);
sb.Append(Environment.NewLine);

foreach (DataRow row in dt.Rows)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
sb.Append(row[i].ToString() + ",");
}

sb.Append(Environment.NewLine);
}

Response.ClearHeaders();
Response.AppendHeader("Content-Disposition", "attachment; filename=" + _Name + ".csv");
Response.AppendHeader("Content-Length", sb.Length.ToString());
Response.ContentType = "text/csv";
Response.Write(sb.ToString());
Response.End();
}

#endregion