C#Export data to CSV

private void ExportData()
{
#region export CSV
List<ViewValidateAZEntityExport> downLoadList = new List<ViewValidateAZEntityExport>();
foreach (DataRow item in dataSet.Rows)
{
    ViewValidateAZEntityExport innerItem = new ViewValidateAZEntityExport();
    innerItem.OriginalId = Convert.ToString(item["id_value"]);
    innerItem.Valid = "Invalid";
    downLoadList.Add(innerItem);
}

string data = string.Empty;
data = ErrorAZIDExportCSV(downLoadList);
string temp = string.Format("attachment;filename={0}", "ExportData.csv");
Response.ClearHeaders();
Response.AppendHeader("Content-disposition", temp);
Response.Write(data);
Response.End();
#endregion Export CSV


#region Export Excel

            //GridView gvAZID = new GridView();
            //gvAZID.EnableViewState = false;
            //Response.AppendHeader("Content-Disposition", "attachment;filename=file.xls");
            //Response.ContentType = "application/ms-excel";
            //this.EnableViewState = false;
            //StringWriter tw = new StringWriter();
            //HtmlTextWriter hw = new HtmlTextWriter(tw);
            //gvAZID.AllowPaging = false;
            //gvAZID.DataSource = downLoadList;
            //gvAZID.DataBind();
            //gvAZID.RenderControl(hw);
            //Response.Write(tw.ToString());
            //Response.End();

#endregion Export Excel

}
private string ErrorAZIDExportCSV(List<ViewValidateAZEntityExport> list)
{
string data = " ";
if (list.Count > 0)
{
    data += "Uploaded ID, ";
    data += "Valid, ";

    data += "\n ";

    foreach (ViewValidateAZEntityExport specItem in list)
    {
    data += specItem.OriginalId + ", ";
    data += specItem.Valid + ", ";

    data += "\n ";
    }
}

return data;
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值