C# 在.net framework框架中导出CSV

Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyy-MM-dd") + ".csv");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.ContentType = "application/excel";
var sb = new StringBuilder();
sb.Append("姓名,工号,性别,部门
");
foreach (var item in query)
{
   sb.Append(""" + item.Name + """ + ",");
   sb.Append(""" + item.Code + """ + ",");
   sb.Append(""" + item.Sex + """ + ",");
   sb.Append(""" + item.deptName + """ + ",");
}

Response.Write(sb.ToString());
Response.End();