outputCSV

protected void OutputCSV(DataView dvResults)
    {
        Response.AppendHeader("content-disposition", "attachment; filename=GiftCardRegistrations.csv");
        Response.ContentType = "application/vnd.ms-excel";
 
        int columns = dvResults.Table.Columns.Count;
 
        //column names
        int i = 0;
        while (i < columns)
        {
            if (i > 0)
                Response.Write(",");
 
            Response.Write(dvResults.Table.Columns[i].ColumnName);
            i++;
        }
 
        Response.Write("\n");
 
 
        // data
        foreach (DataRowView drResults in dvResults)
        {
            i = 0;
            while (i < columns)
            {
                if (i > 0)
                    Response.Write(",");
 
                Response.Write("\"" + drResults[i] + "\"");
                i++;
            }
 
            Response.Write("\n");
        }
 
        Response.End();
    }