How to edit the grid

Question

Hello Community,I'm trying to create an editable grid bind in sql. I tried the code in your documentation but it seems I missed something,

Rajapandiyan Settu · Answer

Hi Rica,   
   
Thanks for contacting Syncfusion support. 
   
Based on your requirement, you want to bind the data from SQL server to DataGrid. You can achieve this requirement by using URL Adaptor. By using this, you can consume data from SQL Server using Microsoft SqlClient and bound it to EJ2 DataGrid.  
   
We have already discussed this in our Knowledge Base. Please refer to the below KB link for more information.  
   
KB: https://www.syncfusion.com/kb/11470/how-to-bind-sql-server-data-in-asp-net-mvc-datagrid-using-sqlclient-data-provider  
   
The URL Adaptor is used to perform On-Demand actions in the EJ2 Grid. This is explained detailly in the below documentation.  
   
URLAdaptor: https://ej2.syncfusion.com/aspnetmvc/documentation/grid/data-binding/#handling-on-demand-grid-actions  
   
When we perform any Grid actions like Searching, Paging, Sorting, Filtering, Exporting, Searching, etc., we send correspond actions details to the server (url method used in the DataManager). You can get these by using DataManagerRequest class in your server method. 
 
Here, you can perform your SQL operation with your data based on the Grid actions queries and return correspond data in object format with result and count value to the Grid.  
 
You can map The CRUD operation in grid can be mapped to server-side Controller actions using the properties InsertUrl, RemoveUrl, UpdateUrl, CrudUrl and BatchUrl. 
 
Please get back to us if you need further assistance with this.  
   
Regards,   
Rajapandiyan S