Force empty rows up to max 20 if datasource has less than 20 rows

[Eddie Willcox]

Hi,

Is it possible to force my grid to show up to a max of 20 empty rows even if the datasource has less than 20 rows?

I am using ajax to populate the grid with data and sometimes, the number of rows are less than 20.

[Sujith Kumar Rajkumar]

Hi Eddie, 

 

Greetings from Syncfusion support. 

 

Based on the query we would like to let you know that, by default the Grid initializes and renders row values based on the data present in the dataSource property. So your requirement of rendering empty rows if the data length is less than 20 can be achieved by pushing empty object value to the Grid’s dataSource property. This can be done in its load event as demonstrated in the below code snippet, 

 

// Grid’s load event handler 

function onLoad() { 

    var grid = document.getElementById('Grid').ej2_instances[0];  

    var dataLen = grid.dataSource.length; 

    while(dataLen < 20) { 

        // Condition executes when Grid data length is less that ‘20’ 

        // Empty object is pushed to the Grid’s data source to render empty row 

        grid.dataSource.push({}); 

        dataLen = grid.dataSource.length; 

    } 

} 

 

API: https://help.syncfusion.com/cr/aspnetmvc-js2/Syncfusion.EJ2.Grids.Grid.html#Syncfusion_EJ2_Grids_Grid_Load 

        https://ej2.syncfusion.com/documentation/api/grid/#datasource 

 

Please get back to us if you require any further assistance. 

 

Regards, 

Sujith R 

[Eddie Willcox]

Thank you. This is exactly what I was looking for

[Sujith Kumar Rajkumar]

Hi Eddie, 

 

You’re welcome. We are glad to hear that your query has been resolved. 

 

Regards, 

Sujith R