// GET: Student
public void Indexs()
{
JameLabEntities jameLabEntites = new JameLabEntities();
var studentList=jameLabEntites.Student.ToList();
var sb = new StringBuilder();
sb.AppendLine("Id,Name,Age,Gender");
foreach (var item in studentList)
{
sb.AppendFormat("{0},{1},{2},{3}", item.Id, item.Name, item.Age, item.Gender);
sb.AppendLine();
}
Response.BufferOutput = true;
Response.Clear();
Response.ClearHeaders();
Response.ContentEncoding = Encoding.Unicode;
Response.AppendHeader("Content-Disposition", "attachment; filename=Test.csv");
Response.ContentType = "text/csv";
Response.Write(sb.ToString());
}
public DefaultModel()
{
StudentList = new JameLabEntities().Student.OrderBy(s=>s.Id).ToList();
}
