How to export and download csv file using c# asp.net web application?

See more:

C#

ASP.NET

SQL-Server

Hello,
How to export and download csv file using c# asp.net web application?
i am using this code for export csv and download in local system:-

SqlConnClass connClass = new SqlConnClass();
DataTable dt = connClass.GetQrCodeDetails();

        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition",
            "attachment;filename=DataTable.csv");
        Response.Charset = "";
        Response.ContentType = "application/text";


        StringBuilder sb = new StringBuilder();
        for (int k = 0; k < dt.Columns.Count; k++)
        {
            //add separator
            sb.Append(dt.Columns[k].ColumnName + ',');
        }
        //append new line
        sb.Append("\r\n");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            for (int k = 0; k < dt.Columns.Count; k++)
            {
                //add separator
                sb.Append(dt.Rows[i][k].ToString().Replace(",", ";") + ',');
            }
            //append new line
            sb.Append("\r\n");
        }
        Response.Output.Write(sb.ToString());
        Response.Flush();
        Response.End();

but my code did its not creating a csv file its not downloading.
Please help me.
Thanks in Advance.

Ankit Agarwal
Software Engineer