export datatable to CSV with Save File Dialog box - C#

Question

Struggling to get my CSV export to display the Save File dialog box up. It saves to file ok, but doesn't let the user save. Can anybody see where I might be going wrong with the code please?

string filename = Server.MapPath("~/download.csv");
StreamWriter sw = new StreamWriter(filename, false);

int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
    sw.Write(dt.Columns[i]);
    if (i < iColCount - 1)
    {                
        sw.Write(",");
    }
}
sw.Write(sw.NewLine);

foreach (DataRow dr in dt.Rows)
{
    for (int i = 0; i < iColCount; i++)
    {
        if (!Convert.IsDBNull(dr[i]))
        {
            sw.Write(dr[i].ToString());
        }
        if (i < iColCount - 1)
        {
            sw.Write(",");
        }
    }
    sw.Write(sw.NewLine);
}
sw.Close();

Response.Clear();
Response.ContentType = "application/csv";
Response.AddHeader("Content-Disposition", "attachment; filename=download.csv");
Response.WriteFile(filename);
Response.Flush();
Response.End();

I thought the Content Disposition line that brought up the dialog box, but maybe there is something else I need to do.

Thanks

Do you need to save the file? Or do you just want to serve it? Also, your CSV writing algo is weak and doens't take into account multi line or commas in values. — banging, Jun 22 '12 at 15:18
Hi, no I don't need to save the file - happy just to serve it. The algo is basic, because that's all it needs - the data that will be getting exported is very basic - about 8 columns, either dates, bools or single words — e-on, Jun 22 '12 at 15:23
Look into Response.BinaryWrite so you can skip the extra overhead from writing/reading the file from disk. — banging, Jun 22 '12 at 16:57

score 2 · Accepted Answer · answered Jun 22 '12 at 16:19

2

Ah, have discovered what the problem is...

I've got the button in an update panel and didn't realise the response object doesn't work in an update panel.

I made the download button a trigger, and it now works great.

<Triggers>
    <asp:PostBackTrigger ControlID="btnDownload" />
</Triggers>

Thanks for the suggestions anyway

answered Jun 22 '12 at 16:19

e-on

1,547
8
32
65

– Erfan Zarger Oct 09 '13 at 17:15

score 0 · Answer 2 · answered Jun 22 '12 at 15:07

0

I'm pretty sure you need

Response.Write()

after

Response.End()

answered Jun 22 '12 at 15:07

Eric Robinson

2,025
14
22

Really? What would I be response.writing, as it would need a string or object? – e-on Jun 22 '12 at 15:20

score 0 · Answer 3 · answered Jun 22 '12 at 16:06

0

You could try clearing the content and the headers after your Response.Clear() call:

    Response.ClearContent();
    Response.ClearHeaders();

answered Jun 22 '12 at 16:06

DaveB

9,470
4
39
66

export datatable to CSV with Save File Dialog box - C#

3 Answers3

Linked