Is there a way we can find out the index of column in grid, if we know the column name in Kendo grid?
e.g.
EmployeeID| Name
123 | John
I want to know the index of 'Name' field i.e. 1 in the grid.
Any suggestions.
Thanks.
Sanjeev
Please try with the below code snippet.
<!DOCTYPE html>
<html>
<head>
<title>Jayesh Goyani</title>
<link rel=stylesheet href=https://kendo.cdn.telerik.com/2015.2.902/styles/kendo.common-bootstrap.min.css />
<link rel=stylesheet href=https://kendo.cdn.telerik.com/2015.2.902/styles/kendo.bootstrap.min.css />
<script src=https://kendo.cdn.telerik.com/2015.2.902/js/jquery.min.js></script>
<script src=https://kendo.cdn.telerik.com/2015.2.902/js/kendo.all.min.js></script>
</head>
<body>
<div id=example></div>
<input type=text id=txtColumnName />
<button onclick=GetColumnIndexFromName();>GetIndex</button>
<script>
$(document).ready(function () {
$(#example).kendoGrid({
dataSource: {
type: odata,
transport: {
read: https://demos.telerik.com/kendo-ui/service/Northwind.svc/Customers
},
pageSize: 20
},
height: 550,
groupable: true,
sortable: true,
pageable: {
refresh: true,
pageSizes: true,
buttonCount: 5
},
columns: [{
template: <div class='customer-name'>#: ContactName #</div>,
field: ContactName,
title: Contact Name,
width: 240
}, {
field: ContactTitle,
title: Contact Title
}, {
field: CompanyName,
title: Company Name
}, {
field: Country,
width: 150
}]
});
});
function GetColumnIndexFromName() {
var index = -1;
var strName = $(#txtColumnName).val();
var grid = $(#example).data(kendoGrid);
var columns = grid.options.columns;
if (columns.length > 0) {
for (var i = 0; i < columns.length; i++) {
if (columns[i].field == strName) { // columns[i].title -- You can also use title property here but for this you have to assign title for all columns
index = i;
}
}
}
if (index == -1) {
alert(column name not exists);
}
else {
alert(column index is:- + index);
}
}
</script>
</body>
</html>
Let me know if any concern.
