<button class="k-button" id="batchGrid">
Batch Edit</button>
<div id="example" class="k-content">
<div id="batchgrid">
</div>
</div>
<script>
$("#batchGrid").click(function () {
var crudServiceBaseUrl = "http://demos.kendoui.com/service",
dataSource = new kendo.data.DataSource({
transport: {
read: {
url: crudServiceBaseUrl + "/Products",
dataType: "jsonp"
},
update: {
url: crudServiceBaseUrl + "/Products/Update",
dataType: "jsonp"
},
destroy: {
url: crudServiceBaseUrl + "/Products/Destroy",
dataType: "jsonp"
},
create: {
url: crudServiceBaseUrl + "/Products/Create",
dataType: "jsonp"
},
parameterMap: function (options, operation) {
if (operation !== "read" && options.models) {
return { models: kendo.stringify(options.models) };
}
}
},
batch: true,
pageSize: 20,
schema: {
model: {
id: "ProductID",
fields: {
ProductID: { editable: false, nullable: true },
ProductName: { validation: { required: true} },
UnitPrice: { type: "number", validation: { required: true, min: 1} },
Discontinued: { type: "boolean" },
UnitsInStock: { type: "number", validation: { min: 0, required: true} }
}
}
}
});
$("#batchgrid").kendoGrid({
dataSource: dataSource,
dataBound: onDataBound,
navigatable: true,
filterable: true,
pageable: true,
height: 430,
width: 300,
toolbar: ["create", "save", "cancel"],
columns: [
"ProductName",
{ field: "UnitPrice", title: "Unit Price", format: "{0:c}", width: "130px" },
{ field: "UnitsInStock", title: "Units In Stock", width: "130px" },
{ field: "Discontinued", width: "130px" },
// { field: "", title: "No", template: "#= ++record #", width: "30px" },
{command: ["destroy"], title: " ", width: "100px"}],
editable: true
});
});
</script>
<script>
function onDataBound(e) {
var grid = $("#batchgrid").data("kendoGrid");
$(grid.tbody).on("keydown", "td", function (e) {
if ((e.keyCode ? e.keyCode : e.which) == 13) { //Enter keycode
var row = $(this).closest("tr");
var rowIdx = $("tr", grid.tbody).index(row);
var colIdx = $("td", row).index(this);
alert(rowIdx + '-' + colIdx);
$this.closest('tr').next().find('td').eq(index).focus();
e.preventDefault();
}
});
}
</script>
in here when i press the enter key in edit mode(inserting new record) i need to go the next cell(as if i press the tab key).
as well as if i press the enter key in last cell(last column) of any row it should move to the first cell(first column) of next row.
i think problem is in my script.but don't know exactly where.
please help me here..
Try this code:-
<script>
$(document).ready(function(){
$("#KendoGridName").keypress(function(e){
var keyCode = e.keyCode || e.which;
if (keyCode == 13) {
var grid = $("#KendoGridName").data("kendoGrid");
var curCell = grid.find(".k-edit-cell");
grid.editCell(curCell.next()); // To move the cursor to the next cell and put the cell in edit mode
grid.select(curCell.next()); // To select the next cell
grid.focus(curCell.next()); // To set focus on to next cell
e.preventDefault(); // To prevent the default behavior of the enter key press
}
});
});
</script>
Note:- Instead of keypress function(e), you can also use keydown function(e){}.
Please pass your comments if the code doesn't work or has some flaws. I tried this in MVC5 and it worked with Kendo Grid.