determine colIndex while editting with kb only

[lawrence greenberg]

We would like to provide an editing experience similar to that of SSMS.  We want to be able to navigate without the mouse, commit a change when changing rows, and be able to identify which cell (or column) has the focus.  It seems that it is not possible to edit if cell selection is used (instead of row selection).  Is it possible to do what we are looking for and if so, how could we do it?

Thank you for your excellent help.

Larry Greenberg

[Farveen Sulthana Thameeztheen Basha]

Hi Lawrence,   

  

Thanks for contacting Syncfusion Support.   

  

We have analyzed your query, and you want to edit the cell (without the use of mouse) and need to navigate over the cell by using keyboard navigation.  For this purpose, Syncfusion has the support of editing known as “Batch editing”.  To enable Batch editing, you need to set “EditMode” as “Batch”.   

  

Please refer to the code example and Help document link.   

  

@(Html.EJ().Grid<Object>("FlatGrid")   

            .Datasource((IEnumerable<object>)ViewBag.DataSource)   

            .AllowPaging()   

            .EditSettings(edit => { edit.AllowAdding().AllowDeleting().AllowEditing().EditMode(EditMode.Batch); })   

            .Columns(col =>   

               {   

                   col.Field("OrderID").HeaderText("Order ID").IsPrimaryKey(true).TextAlign(TextAlign.Right).Add();   

                  .  .  .   

   

              }))   

  

  

https://help.syncfusion.com/aspnetmvc/grid/editing#batch--excel-like   

  

If you want to perform server side CRUD operations in Batch editMode, you can use the property “BatchURL”. Please refer to the Help document:https://help.syncfusion.com/aspnetmvc/grid/editing#batch-url   

  

Refer to the Help Document and Online Demo link:  

Online Demo: http://mvc.syncfusion.com/demos/web/grid/batchediting   

  

In addition to this, there are methods such as “batchCancel”, “batchSave”, “editCell”, “getBatchChanges” and events such as “batchAdd”, “batchDelete”,” beforeBatchAdd”, “beforeBatchDelete”, “beforeBatchSave” ,“cellEdit”  and  “cellSave” to support Batch editing.   

  

API reference link: https://help.syncfusion.com/api/js/ejgrid   

  

Let us know if you need any further assistance.   

  

Regards,   

  

Farveen Sulthana T.  

[Gangabharathy Murugasen]

From: [e-mail] [mailto:[e-mail]]
Sent: Friday, April 28, 2017 9:10 AM
To: Syncfusion Support <[e-mail]>
Subject: RE: Syncfusion support community forum 130210, determine colIndex while editting with kb only, has been updated. 

Thank you, Farveen. 

[Gangabharathy Murugasen]

HI Lawrence, 

Thanks for the update, Please let us know whether you required any other assistance on this. 

Regards,
M. Ganga