How to stop the first column to be editable

[David Price]

Hi,

My Grid is auto generated so the code looks like this

How can I stop column 1 from getting edited. I tried in the createEvent function

args.model.columns[0]['AllowEditing'] = false;

gridObj.columns(args.model.columns);

but this doesn't work ?

[Thavasianand Sankaranarayanan]

Hi David, 

Thanks for contacting Syncfusion support. 

As per your given detail we suspect that you want to disable the editing for the first column in Grid when we are in auto generation for column. We can achieve your requirement by using the dataBound event of ejGrid control.  

Refer the below code example. 

<ej:Grid ID="FlatGrid" runat="server" AllowSorting="True" AllowPaging="True" IsResponsive="true"> 

            <EditSettings AllowEditing="true" AllowAdding="true" AllowDeleting="true"></EditSettings> 

           <ToolbarSettings ShowToolbar="true" ToolbarItems="add,edit,delete,update,cancel"></ToolbarSettings> 

             

            <ClientSideEvents DataBound="onGridDataBoundEvent" /> 

             

        </ej:Grid> 

    </div> 

      

    <script type="text/javascript"> 

        function onGridDataBoundEvent(args) { 

 

            this.model.columns[1].allowEditing = false; 

            this.refreshContent(true); //Reflect the changes in grid 

 

        } 

    </script> 

Note: The editing operation works based on the PrimaryKey column value. So the values for the Primary Key column should be unique. Also we suspect that you have not enable isPrimaryKey for unique value column then we suggest you to set isPrimaryKey for the unique value column in Grid. If the PrimaryKey column and need to set allowEditing as false columns are same then we need to enable only isPrimaryKey for that column. By default when a record is editable state then the PrimaryKey column is disabled so we suggest you to remove the allowEditing as false for the primary key column. 

Refer the help documentation. 

Link: https://help.syncfusion.com/api/js/ejgrid#events:databound 

Link: https://help.syncfusion.com/api/js/ejgrid#members:columns-isprimarykey 

Link: https://help.syncfusion.com/aspnet/grid/editing 

Refer the knowledge base documentation. 

KB link: https://www.syncfusion.com/kb/2675/cant-edit-any-row-except-the-first-row-in-grid 

KB link: https://www.syncfusion.com/kb/7130/how-to-format-and-add-isprimarykey-property-to-auto-generated-columns 

Regards, 

Thavasianand S. 

[David Price]

How can I disable rows from being editable also ?

for example I don't want row 3 & 4 to be editable .

[Vignesh Natarajan]

Hi David, 

 

 

Query: “How can I disable rows from being editable also ?” 

 

 

From your query, we understand that you want to certain row from editing. We have achieved your requirement using BeginEdit event of ejGrid. 

 

Refer the below code example 

 

 

<ej:Grid ID="FlatGrid" runat="server" AllowScrolling="True" AllowSorting="True" AllowPaging="True" IsResponsive="true">  

            <EditSettings AllowEditing="true" AllowAdding="true" AllowDeleting="true"></EditSettings>  

           <ToolbarSettings ShowToolbar="true" ToolbarItems="add,edit,delete,update,cancel"></ToolbarSettings>              

            <ClientSideEvents DataBound="onGridDataBoundEvent" BeginEdit="beginedit"/>     

           <ScrollSettings FrozenColumns="2" />          

        </ej:Grid>  

          <script type="text/javascript">  

              function onGridDataBoundEvent(args) { 

                  this.model.columns[0].isPrimaryKey = true; 

            this.model.columns[1].allowEditing = false;  

            this.refreshContent(true); //Reflect the changes in grid   

        } 

              function beginedit(args){ 

                  if (args.rowIndex == 3 || args.rowIndex == 4) 

                      args.cancel = true; 

} 

    </script> 

 

For your convenience we have prepared a sample which can be downloaded from below link 

 

 

Sample: http://www.syncfusion.com/downloads/support/forum/140572/ze/SyncfusionASPNETApplication18959765222  

 

 

Refer our API documentation for your reference 

 

 

https://help.syncfusion.com/api/js/ejgrid#events:beginedit  

 

 

Regards, 

Vignesh Natarajan