EJ2 Grid MVC Display Row Number

RouX

Asked On February 21, 2019 03:57 AM UTC

Hi,

Thanks for giving an opportunity to use Syncfusion Tools for free on trial. It is very usefull tool.

I need to display row numbers on grid. I did some research. In older and different platforms there was a property called RowHeader.

But I couldn't find any good solution for my case on EJ2 Grid for MVC. I don't want to add row_number() to my sql queries.

I just want to handle this on grid. Is there a best practice for that? How could I achive this?

Please advise,

Thanks.

Reply | Reply with quote

Thavasianand Sankaranarayanan [Syncfusion]

Replied On February 22, 2019 10:26 AM UTC

Hi Sue,

Greetings from Syncfusion.

Based on your query we suspect that you want to show the row numbers in Grid. We can achieve your requirement using the queryCellInfo event of Grid.

Refer the below code example.

@Html.EJS().Grid("FlatGrid").DataSource((IEnumerable<object>)ViewBag.dataSource).QueryCellInfo("querycellinfo").Columns(col =>

{

col.HeaderText("Row Numer").Width("90").Add();

col.Field("EmployeeID").HeaderText("Employee ID").IsPrimaryKey(true).Width("120").Add();

col.Field("CustomerID").HeaderText("Customer Name").Width("150").Add();

col.Field("OrderDate").HeaderText("Order Date").Type("date").Width("110").Add();

col.Field("Freight").HeaderText("Freight").EditType("numericedit").Width("120").Add();

col.Field("ShipCountry").HeaderText("Ship Country").Width("150").Add();

}).AllowPaging().Render()

var count = 1;

function querycellinfo(args) {

if (args.column.headerText == "Row Numer") {

args.cell.innerHTML = count;

count++;

}

</script>

Refer the below screen shot.

Please let us know if you need further assistance on this.

Regards,

Thavasianand S.

Reply | Reply with quote

RouX

Replied On February 22, 2019 01:27 PM UTC

Hi,

Thanks for your fast reply. This is awesome solution for my case. I applied the code but there are some logics to be handled. I'll try to handle those.

For now I applied those on actionBegin:

if (args.requestType == "paging" || args.requestType == "sorting" || args.requestType == "grouping" ||

args.requestType == "filtering" || args.requestType == "searching" || args.requestType == "close")

count = 1;

Regards.

Reply | Reply with quote

Thavasianand Sankaranarayanan [Syncfusion]

Replied On February 25, 2019 11:53 AM UTC

Hi Cahid,

We are happy that the problem has been solved.

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

Regards,

Thavasianand S.

Reply | Reply with quote

Thread ID:	Created:	Updated:	Platform:	Replies:
142823	Feb 21,2019 03:57 AM UTC	Feb 25,2019 11:53 AM UTC	ASP.NET MVC - EJ 2	3

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US