How implement Lock Row

[Alfonso]

Good day.

I need your support, I want to implement an example of "Lock Row"(https://asp.syncfusion.com/demos/web/grid/lockrow.aspx) in my project without dropdownlist that used in the example, consists of certain rows with specific content that will be blocked and can't be edited and other rows that can be edited i want runs automatically when the Grid has Binded.

in the image put weren't  row can be edited who data your valour be > 0 (Zero)

Add my code and an img of my project.

Thank you and thank you for your support.

Attachment: LockRow_47e39fb9.7z

[Farveen Sulthana Thameeztheen Basha]

Hi Alfonso, 

 

Thanks for contacting Syncfusion Support. 

 

Query#:- specific content that will be blocked and can't be edited and other rows that can be edited i want runs automatically when the Grid has Binded. 

 

Thanks for contacting Syncfusion Support. 

 

We have checked your query and  achieved your requirement through BeginEdit event of the Grid. In the BeginEdit event based on the value of the row, we have set args.cancel as true to prevent Editing for that row while on rendering of Grid. 

 

Please refer to the code example:- 

<ej:Grid ID="OrdersGrid" runat="server" AllowPaging="True" OnServerEditRow="EditEvents_ServerEditRow">  

            <ClientSideEvents ActionComplete="complete" BeginEdit="beginEdit" EndEdit="endEdit" /> 

            <Columns> 

                <ej:Column Field="OrderID" HeaderText="Order ID" IsPrimaryKey="true" TextAlign="Right" Width="75" /> 

                <ej:Column Field="ShipCity" HeaderText="Ship City" Width="120" /> 

                  .     .    . 

            </Columns> 

                    </ej:Grid> 

          

    

   <script type="text/javascript"> 

        

        function beginEdit(args) { 

              if(args.rowData.EmployeeID > 3){  //Change as per your fieldName value 

                     args.cancel = true; 

           } 

        }          

    </script> 

        

Please get back to us if you need any further assistance. 

Regards, 

Farveen sulthana T 

[Alfonso]

Hello, good day.

Thank you for your answer your code can be adapting very well  and works great; but and now i have a one more question.

How change a default value that show, than the result only shows the first data in the cell that can be edited for the grid without respecting the record to be edited.

i'll attach the code and img  the show them my cuestion.

Thank you for your supporting

Attachment: LockRow2_652f1d52.7z

[Alfonso]

Hello, good day.

Thank you for your answer your code can be adapting very well  and works great; but and now i have a one more question.

How change a default value that show, than the result only shows the first data in the cell that can be edited for the grid without respecting the record to be edited.

i'll attach the code and img  the show them my cuestion.

Thank you for your supporting

Attachment: LockRow2_652f1d52.7z

and  one thing more.

i can was set focus row on the first position of the grid when load the grid, can be done?

Grettings.

[Vignesh Natarajan]

Hi Alfonso,   

  

Thanks for the update.   

  

Query:1 “How change a default value that show, than the result only shows the first data in the cell that can be edited for the grid without respecting the record to be edited.”  

  

From your query, we understand that you are facing issue (getting first record values instead of corresponding record value) while editing a record. We have already discussed this topic in our knowledge base document. Kindly refer the below link for the knowledge base document.  

  

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

  

We have analyzed the provided code example and found that you have used multiple IsPrimaryKey and also their values are not unique. For editing action, PrimaryKey column must be defined and its value must be unique. Since your primaryKey values are not unique reported issue, occur.   

  

Kindly ensure to define the primaryKey property to column which has unique values.   

  

Query2: “i can was set focus row on the first position of the grid when load the grid, can be done?”  

  

As we quite unclear about your requirement, kindly share the following details which will be helpful for us to validate the reported query at our end.   

  

1. Do you want to select the first record by default?  

2. Or do you want to focus the first cell while editing a record?  

3.  If not share more details about your requirement.  

  

Regards,  

Vignesh Natarajan.  

[Alfonso]

Query2: “i can was set focus row on the first position of the grid when load the grid, can be done?”  

  

As we quite unclear about your requirement, kindly share the following details which will be helpful for us to validate the reported query at our end.   

  

1. Do you want to select the first record by default?  <-- i want this...
   

2. Or do you want to focus the first cell while editing a record?  

3.  If not share more details about your requirement.
   
4. 
   
5.  
   
6. i send you video who demonstrate were a i want
   

Attachment: LockRow_d4b2794c.7z

[Farveen Sulthana Thameeztheen Basha]

Hi  Alfonso, 

  

Do you want to select the first record by default?  <-- i want this... 

 

Solution#1:- 

We have checked your query and if you want to select the firstRecord by default you can use selectRows method of the Grid on DataBound event of the Grid.  

 

Solution#2:- 

Otherwise you can use SelectedRowIndex property of the Grid on rendering of the Grid. Please refer to the code example:- 

 

<ej:Grid ID="OrdersGrid" runat="server" AllowPaging="True" SelectedRowIndex="0" EnableHeaderHover="True"> 

           <ClientSideEvents DataBound="bound" /> 

            <Columns> 

                <ej:Column Field="OrderID" HeaderText="Order ID" IsPrimaryKey="True" AllowEditing="false" TextAlign="Right" Width="90" /> 

            </Columns> 

             

       <script type="text/javascript"> 

           function bound(args) { 

               this.selectRows(0); 

           } 

       </script> 

Please ensure that you have used the above solution in your sample. After following this solution still facing the issue, please share us the following details. 

1. Complete Grid code example(both in server and client side).
2. Exact scenario you have faced the issue.

Regards, 

Farveen sulthana T