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;
}
7 回答
海綿寶寶撒
TA貢獻1809條經(jīng)驗 獲得超8個贊
在web.config中設(shè)置一下請求超時設(shè)置：
<httpRuntime executionTimeout="300"/>
單位是秒，默認是110秒。
- 7 回答
- 0 關(guān)注
- 583 瀏覽
添加回答
舉報
0/150
提交
取消