Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
144112 | Apr 19,2019 02:52 AM UTC | May 8,2019 08:53 AM UTC | ASP.NET MVC - EJ 2 | 3 |
![]() |
Tags: Grid |
@Html.EJS().Grid("FirstGrid").DataSource((IEnumerable<object>)ViewBag.DataSource).AllowFiltering().AllowResizing(true).AllowExcelExport().ToolbarClick("toolbarClick").Toolbar(new List<string>() { "ExcelExport" }).Columns(col =>
{
...
}).AllowPaging().ExcelExportComplete("complete").Render()
@Html.EJS().Grid("SecondGrid").DataSource((IEnumerable<object>)ViewBag.DataSource1).AllowExcelExport().Columns(col =>
{
...
}).AllowPaging().Render()
<script>
function toolbarClick(args) {
var cols = [];
var firstGrid = document.getElementById("FirstGrid").ej2_instances[0];
var initCols = firstGrid.columns;
var initDataSource = firstGrid.dataSource;
var exportData = [];
var secondGrid = document.getElementById("SecondGrid").ej2_instances[0];
for (var i = 0; i < firstGrid.columns.length; i++) {
cols.push(firstGrid.columns[i]) //adding first grid columns
}
for (var i = 0; i < secondGrid.columns.length; i++) {
cols.push(secondGrid.columns[i]) //adding second grid columns
}
firstGrid.columns = [];
firstGrid.columns = cols; //assign new columns to first grid
if (args.item.id === 'FirstGrid_excelexport') {
var excelExportProperties = {
dataSource: ej.base.extend(exportData, firstGrid.dataSource, secondGrid.dataSource, true) //extending grid dataSource
};
firstGrid.excelExport(excelExportProperties);
}
}
function complete(args) {
var firstGrid = document.getElementById("FirstGrid").ej2_instances[0];
var secondGrid = document.getElementById("SecondGrid").ej2_instances[0];
for (var i = 0; i < firstGrid.columns.length; i++)
{
for (var j = 0; j < secondGrid.columns.length; j++)
{
if (firstGrid.columns[i] == secondGrid.columns[j])
{
firstGrid.columns.splice(i, 1); //removing added columns from first grid
}
}
}
firstGrid.refreshColumns();
}
</script> |
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.