CODEWITHSUNDEEP
c#asp.netcsvresponse
Arun
Arun

Reputation: 1482

Converting Datatable to Csv having some issue in Response.End()

I am trying to convert datatable to csv format.The code is working and the getting the csv correctly.But the problem is there is some exception is showing the catch block after Response.End();

here is my code

 public void GetCSV(DataTable dt)
    {
        StringBuilder sb = new StringBuilder();
        IEnumerable<string> columnNames1 = dt.Columns.Cast<DataColumn>().
            Select(column => column.ColumnName);
        sb.AppendLine(string.Join(",", columnNames1));
        foreach (DataRow row in dt.Rows)
        {
            IEnumerable<string> fields = row.ItemArray.Select(field => field.ToString());
            foreach (var item in fields)
            {
                sb.AppendFormat("\"{0}\",", item.Replace("\"", "\"\""));
            }
            sb = sb.Remove(sb.Length - 1, 1);
            sb.Append("\n");
            //sb.AppendLine(string.Join(",", fields));
        }

        string attachment1 = "attachment; filename=Application_Data.csv";
        Response.ClearContent();
        Response.AddHeader("content-disposition", attachment1);
        Response.ContentType = "application/csv;charset=utf-8";
        Response.Charset = "utf-8";
        Response.Write(sb.ToString());
        Response.End();
    }

I just debug and check .then the Response.End having the issue the error showing is Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack

Can any one know what is the issue.Thanks in advance for help.

Upvotes: 1

Views: 456

Answers (2)

Manoj
Manoj

Reputation: 5071

Try this

public void ExportToCSVFile(DataTable dt, string file_name)
        {
            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition",
             "attachment;filename='" + file_name + "'.csv");
            Response.Charset = "";
            Response.ContentType = "application/text";
            StringBuilder sb = new StringBuilder();
            for (int k = 0; k < dt.Columns.Count; k++)
            {
                sb.Append(dt.Columns[k].ColumnName + ',');
            }
            sb.Append("\r\n");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                for (int k = 0; k < dt.Columns.Count; k++)
                {
                    sb.Append(dt.Rows[i][k].ToString() + ',');
                }
                sb.Append("\r\n");
            }
            Response.Output.Write(sb.ToString());
            Response.Flush();
            Response.End();
        }

Pass datatable and file name in this function.

Upvotes: 2

Constant Learner
Constant Learner

Reputation: 525

var lines = new List<string>();

string[] columnNames = dataTable.Columns.Cast<datacolumn>().
                                  Select(column => column.ColumnName).
                                  ToArray();

var header = string.Join(",", columnNames);
lines.Add(header);

var valueLines = dt.AsEnumerable()
                   .Select(row => string.Join(",", row.ItemArray));            
lines.AddRange(valueLines );

File.WriteAllLines("excel.csv",lines);</datacolumn></string>

Upvotes: 1

Related Questions