public ActionResult ExportToExcel()
{
var rvspService = new RvspService();
var ds = rvspService.ModifiedRvsp();
var data = from s in ds
select new
{
s.Namn,
s.Email,
s.Kommer,
s.Boende,
s.AntalNätter,
s.MatInfo,
s.Kommentar,
};
var list = data.ToList();
var grid = new GridView();
grid.DataSource = list;
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Bröllop_OSA.xls");
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return(View("Index", ds));
}
public ActionResult Index()
{
var requestCookie = Request.Cookies["AuthID"];
try
{
if (requestCookie == null || requestCookie.Value != Session["AuthID"].ToString())
{
return(View("Index"));
}
}
catch
{
return(View("Index"));
}
var rvspService = new RvspService();
var rvsp = rvspService.ModifiedRvsp();
return(View(rvsp));
}