C# 实现下载csv，数据太多，请求超时，求解决办法！！！急！！！

Question

RT
代码：

protected void btnReport_Click(object sender, EventArgs e)
    {
        IList<Member> StudentList = Search();
        string data = ExportCSV(StudentList);
        string temp = string.Format("attachment;filename={0}", DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv");
        Response.ClearHeaders();
        Response.AppendHeader("Content-disposition", temp);
        Response.HeaderEncoding = Encoding.GetEncoding("shift-jis");
        Response.ContentType = "application/octet-stream";
        Response.ContentEncoding = Encoding.GetEncoding("shift-jis");
        Response.Write(data);
        Response.Flush();
        Response.Close();
        IsReport = false;
    }

public string ExportCSV(IList<Member> list)
    {
        string data = "";
        data = "First name,Last name,DOB,Email,Phone number,Gender,Points,Rank,Address,Suburb,Postcode,School,Avatar Name,Username,Password,DataCreated,Activated status\n";
        foreach (Member tb in list)
        {

            data += "\"" + tb.FirstName + "\","
                    + "\"" + tb.LastName + "\","
                    + "\"" + tb.DateOfBirth + "\","
                    + "\"" + tb.Email + "\","
                    + "\"" + tb.PhoneNumber + "\","
                    + "\"" + (tb.Gender == "F" ? "Female" : (tb.Gender == "M" ? "Male" : "")) + "\","
                    + "\"" + tb.Points + "\","
                    + "\"" + (tb.Rank == null ? "" : tb.Rank.Name) + "\","
                    + "\"" + tb.Address + "\","
                    + "\"" + tb.Suburb + "\","
                    + "\"" + tb.Postcode + "\","
                    + "\"" + (tb.School == null ? "" : tb.School.Name) + "\","
                    + "\"" + tb.Nickname + "\","
                    + "\"" + tb.Username + "\","
                    + "\"" + tb.Password + "\","
                    + "\"" + tb.DateCreated + "\","
                    + "\"" + tb.IsActive + "\","
                 + "\n";
        }
        return data;
    }

Answer 1

数据库的话用DATAREADER一条条的写进WEB页面中..不要写进LIST中

Answer 2

没用到Datareader，用的Nhibernate。

Answer 3

在web.config中设置一下请求超时设置： <httpRuntime executionTimeout="300"/> 单位是秒，默认是110秒。

Answer 4

非常感谢~已经设置过了，虽说能起作用，但是还是时间超长。

Answer 5

非常感谢~同1楼。