or
$scope.mainGridOptions.dataSource.read({ data: $scope.searchText });var gridData = new kendo.data.DataSource({ transport: { read: { url: "api/engagement/GetEngagementLists", data: { searchStr: $scope.searchText }, type: "GET", contentType: "application/json" } }, schema: { data: "Data", total: "Count", errors: "Errors" }, error: (e) => { console.log("error"); toastFactory.error("error"); }, pageSize: 10, serverPaging: true, serverSorting: true });<div class="col-lg-12"> <h3>Overall</h3> <h5>Value</h5> @(Html.Kendo().Chart(Model.LineChartDataVALTOT) .Name("TOTVALLineChart") .Theme("Silver") .ChartArea(chartArea => chartArea .Background("white") ) .DataSource(dataSource => dataSource .Group(group => group.Add(model => model.Element)) .Sort(sort => sort.Add(model => model.TransactionDate).Ascending()) ) .HtmlAttributes(new { style = "height:250px;" }) .Series(series => { series.Line(model => model.Value, categoryExpression: model => model.TransactionDate) .Name("#= group.value #"); }) .Legend(legend => legend .Visible(false) ) .ValueAxis(axis => axis.Numeric("Value") .Labels(labels => labels .Format("R {0:N}") .Skip(2) .Step(2) ) ) .CategoryAxis(axis => axis .Categories(model => model.TransactionDate) .Date() .BaseUnit(ChartAxisBaseUnit.Days) .BaseUnitStep(7) ).Tooltip(tooltip => tooltip .Visible(true) .Format("R {0:N}") ) )</div> <div> @(Html.Kendo() .Grid<TitleListModel>() .Name("TitleList") .ToolBar(toolBar => toolBar.Custom() .Text("Export To Excel") .HtmlAttributes(new { id = "export" }) .Url(Url.Action("ExportNominalReportTitleGrid", "Dashboard", new { storeId = @Model.Stores.SelectedStoreId, page = 1, pageSize = "~", filter = "~", sort = "~" }))) .Columns(columns => { columns.Bound(c => c.ISBN13); columns.Bound(c => c.Title); columns.Bound(c => c.Author); columns.Bound(c => c.Publisher); columns.Bound(c => c.Value).Format("R {0:n2}").Title("Value"); columns.Bound(c => c.Quantity).Format("{0:n0}").Title("Quantity"); columns.Bound(c => c.ASP).Format("R {0:n2}").Title("ASP"); }) .Events(ev => ev.DataBound("onDataBound")) .Scrollable() .Groupable() .Sortable() .Pageable(pageable => pageable .Refresh(true) .PageSizes(true) .ButtonCount(3)) .DataSource(dataSource => dataSource .Ajax() .PageSize(20) .Read(read => read.Action("NominalReportTitleGrid", "Dashboard", new { storeId = @Model.Stores.SelectedStoreId }))) ) </div>function onDataBound(e) { var grid = $('#TitleList').data('kendoGrid'); // ask the parameterMap to create the request object for you var requestObject = (new kendo.data.transports["aspnetmvc-server"]({ prefix: "" })) .options.parameterMap({ page: grid.dataSource.page(), sort: grid.dataSource.sort(), filter: grid.dataSource.filter() }); // Get the export link as jQuery object var $exportLink = $('#export'); // Get its 'href' attribute - the URL where it would navigate to var href = $exportLink.attr('href'); //console.log("EXPORT" + href); // Update the 'page' parameter with the grid's current page href = href.replace(/page=([^&]*)/, 'page=' + requestObject.page || '~'); // Update the 'sort' parameter with the grid's current sort descriptor href = href.replace(/sort=([^&]*)/, 'sort=' + requestObject.sort || '~'); // Update the 'pageSize' parameter with the grid's current pageSize href = href.replace(/pageSize=([^&]*)/, 'pageSize=' + grid.dataSource._pageSize); //update filter descriptor with the filters applied href = href.replace(/filter=([^&]*)/, 'filter=' + (requestObject.filter || '~')); // Update the 'href' attribute //console.log("EXPORT" + href); $exportLink.attr('href', href);}$('#ddCategories').kendoDropDownList();$('#ddProducts').kendoDropDownList();