Extraction list to filter different records from db in asp.net mvc

Hi Team

I have a button, but i want to know how can i extract the list of records from the button itself when clicked

public IList < ScheduleManModel > GetScheduleManList()
{
DbAccessContext db = new DbAccessContext();
var scheduleList = (from e in db.ScheduleMan join d in db.ScheduleTbl on e.ScheduleId equals d.YearTblId select new ScheduleManModel {
Year = e.Year,
Week = e.Week,
250 Buck = (int) e.250 Buck,
RACS = e.RACS,
YBR250 = d.YBR250
}).ToList();
return scheduleList;
}
public ActionResult ExtractionToExcel() {
var gv = new GridView();
gv.DataSource = this.ScheduleManList();
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=DemoExcel.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
gv.RenderControl(objHtmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
return View("Index");
}
}
}

Using asp.net mvc to export them as excel, has anyone ever worked on that before?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg5y ago
Accepted answer
See this link but change as per your requirement, https://www.c-sharpcorner.com/article/export-data-excel-in-asp-net-mvc/ https://www.c-sharpcorner.com/article/export-data-in-excel-file-with-asp-net-mvc/ https://www.aspsnippets.com/Articles/Export-to-Excel-in-ASPNet-MVC.aspx
Guest User5y ago
Hi Salman

Thanks

I was about to ask, as to how to format the data as excel? and regarding using Model, if i am using Ado.Net, saw the last article has that information, thanks man.