public string ExportCSV(DataSet ds)
{
StringBuilder sb = new StringBuilder(10000);
if (ds != null)
{
foreach (DataTable tb in ds.Tables)
{
foreach (DataColumn column in tb.Columns)
{
sb.Append(column.ColumnName.ToLower() + ",");
}
sb.Append("/n");
foreach (DataRow row in tb.Rows)
{
foreach (DataColumn column in tb.Columns)
{
sb.Append(row[column].ToString() + ",");
}
sb.Append("/n");
}
sb.Append("/n");
}
return sb.ToString();
}
else
{
return "";
}
}
string name="test2";
string data = ExportCSV(ds1);
string temp = string.Format("attachment;filename={0}", name);
Response.ClearHeaders();
Response.AppendHeader("Content-disposition", temp);
Response.Write(data);
Response.End();