Add row in Grid above selected row

Environment

Product

Progress® Kendo UI® Grid for jQuery

Description

How can I add add a row above the selected row in the Grid?

Solution

1. To achieve such behavior you can add a custom button in the toolbar using the Grid toolbar template option.

2. Find the index of the currently selected Grid row.

3. Then, you could use the dataSource insert method.

  <div id="grid"></div>

  <script>
    function toolbar_click(e) {
      var index = $('tr.k-selected').index(); //index of the selected row
      var grid = $("#grid").data("kendoGrid");
      var dataSource = grid.dataSource;
      var newItem = dataSource.insert(index, {});
      var newRow = grid.items().filter("[data-uid='" + newItem.uid + "']");
      grid.editRow(newRow);
    }
    var crudServiceBaseUrl = "https://demos.telerik.com/service/v2/core",
      dataSource = new kendo.data.DataSource({
          transport: {
              read:  {
                  url: crudServiceBaseUrl + "/Products"
              },
              update: {
                  url: crudServiceBaseUrl + "/Products/Update",
                  type: "POST",
          		contentType: "application/json"
              },
              destroy: {
                  url: crudServiceBaseUrl + "/Products/Destroy",
                  type: "POST",
          		contentType: "application/json"
              },
              create: {
                  url: crudServiceBaseUrl + "/Products/Create",
                  type: "POST",
          		contentType: "application/json"
              },
              parameterMap: function(options, operation) {
                  if (operation !== "read" && options.models) {
                      return 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 } }
              }
            }
          }
        });

    $("#grid").kendoGrid({
      dataSource: dataSource,
      pageable: true,
      height: 550,
      selectable: true,
      toolbar: [
        {
          template: '<button class="k-button k-button-md k-button-rectangle k-rounded-md k-button-primary tton-solid-primary" onclick="return toolbar_click()">custom Add Command</button>'
        },
        "create"
      ],
      columns: [
        "ProductName",
        { field: "UnitPrice", title: "Unit Price", format: "{0:c}", width: "120px" },
        { field: "UnitsInStock", title:"Units In Stock", width: "120px" },
        { field: "Discontinued", width: "120px" },
        { command: ["edit", "destroy"], title: "&nbsp;", width: "250px" }],
      editable: "inline"
    });
  </script>