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;
}
{
#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;
}