I'm having issue with mvc grid export to excel (using 2015.1.318 trial mvc version). grid populates fine. export to excel works with smaller records.. but when downloading bigger size of file, it errors as "Failed to load resource: the server responded with a status of 500 (Internal Server Error)" however, read method /Report/GetGridData controller fine. it's dynamically creating columns from datatable. Does anyone have any clue what I might be doing wrong here ?
2015.1.318 trial mvc version
MVC5
VS2012
--- controller
[HttpPost]
public ActionResult GetGridData([DataSourceRequest] DataSourceRequest request, string spName, string program, string fromDate, string toDate)
{
DataTable _dataTable = new DataTable();
ReportData reportData = new ReportData();
user = UserManager.FindByNameAsync(User.Identity.Name).Result;
_dataTable = reportData.GetSPData(spName, user.Id, program, fromDate, toDate);
return Json(_dataTable.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
--- cshml
@(Html.Kendo().Grid<dynamic>()
.Name("abcGrid")
.Columns(columns =>
{
foreach (System.Data.DataColumn column in Model.Columns)
{
var c = columns.Bound(column.ColumnName).Title(column.ColumnName).Width(150);
}
})
.Excel(excel => excel
.AllPages(true)
.FileName("abcGridExport.xlsx")
.ProxyURL(Url.Action("Excel_Export_Save", "Grid"))
)
.Pageable()
.AutoBind(false)
.Sortable()
.ToolBar(tools => tools.Excel())
.Filterable()
.DataSource(dataSource => dataSource
.Ajax()
.Model(model =>
{
foreach (System.Data.DataColumn column in Model.Columns)
{
var field = model.Field(column.ColumnName, column.DataType);
}
})
.Read(read => read.Action("GetGridData", "Report").Data("readparameter"))
)
)
2015.1.318 trial mvc version
MVC5
VS2012
--- controller
[HttpPost]
public ActionResult GetGridData([DataSourceRequest] DataSourceRequest request, string spName, string program, string fromDate, string toDate)
{
DataTable _dataTable = new DataTable();
ReportData reportData = new ReportData();
user = UserManager.FindByNameAsync(User.Identity.Name).Result;
_dataTable = reportData.GetSPData(spName, user.Id, program, fromDate, toDate);
return Json(_dataTable.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
--- cshml
@(Html.Kendo().Grid<dynamic>()
.Name("abcGrid")
.Columns(columns =>
{
foreach (System.Data.DataColumn column in Model.Columns)
{
var c = columns.Bound(column.ColumnName).Title(column.ColumnName).Width(150);
}
})
.Excel(excel => excel
.AllPages(true)
.FileName("abcGridExport.xlsx")
.ProxyURL(Url.Action("Excel_Export_Save", "Grid"))
)
.Pageable()
.AutoBind(false)
.Sortable()
.ToolBar(tools => tools.Excel())
.Filterable()
.DataSource(dataSource => dataSource
.Ajax()
.Model(model =>
{
foreach (System.Data.DataColumn column in Model.Columns)
{
var field = model.Field(column.ColumnName, column.DataType);
}
})
.Read(read => read.Action("GetGridData", "Report").Data("readparameter"))
)
)