We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Sample about Grid and performing CRUDperations on it MVC (non-Classic)

Please provide an example by which I can perform CRUD operation on a Model data from SQL Server and SQL LocalDb with save, update, delete button in Each Row and also actual data is updated in database.

Thanks & Regards

4 Replies

RO Rohith August 1, 2014 10:48 AM UTC

Hi Rajeev,

I have used ClientSideEvent ActionComplete to catch the event of adding /editing rows in Grid.

You can check the request type as (add/edit)  and call an MVC action which saves the data to DB.

Help link which I used: http://mvc.syncfusion.com/demos/web/Grid/ExternalFormEditing


AS Alan Sangeeth S Syncfusion Team August 4, 2014 03:17 PM UTC

Hi Rajeev,


Thanks for using Syncfusion Products.


We would like to let you know that using “Commands” property of Columns we can add Save, Edit, Update and Cancel buttons to each row. Please refer the following code snippets.



.Columns(col =>


col.HeaderText("Manage Records").Commands(command =>



                       .ButtonOptions(new Syncfusion.JavaScript.Models.ButtonProperties()


                           Text = "Edit"



                       .ButtonOptions(new Syncfusion.JavaScript.Models.ButtonProperties()


                           Text = "Cancel"






Then using “RemoteSaveAdaptor”, we have Performed CRUD operations in Grid. The insert, update, delete action in Grid will be mapped to the controller action spectified in the CRUD urls (InsertUrl, UpdateUrl, RemoveUrl). Please refer the following code snippets.



        .Datasource(ds => ds.Json((IEnumerable<object>)ViewBag.datasource).UpdateURL("Home/Update")






/Edited Record values will get binded to this action

public ActionResult Update(EditableOrder value) {


            var data = OrderRepository.GetAllRecords();

            return Json(data, JsonRequestBehavior.AllowGet);



For your convenience we have created a sample and the same can be downloaded from below link.


Sample: http://www.syncfusion.com/downloads/support/directtrac/127595/EJGrid-1292646861.zip


We also would like to let you know that in the above we have an issue that “On Record Delete Grid Pager TotalRecord Count not updated until page refresh”. We have logged defect report for this and the fix for this issue will be included in 2014 Volume 2 Service Pack 2 release.


Please let us know if you have any queries.


Alan Sangeeth S

RU Ragavee U S Syncfusion Team September 2, 2014 06:41 AM UTC

Hi Rajeev,


We are glad to announce that our  Essential Studio service pack-2 for Volume 2, 2014 is rolled out and is available for download under the following link.




The fix for the issue “On Record Delete Grid Pager TotalRecord Count not updated until page refresh” is included in the above provided link.


We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.



Ragavee U S

JA James September 30, 2014 03:59 AM UTC

Do you have an example using WebApi for CRUD operations? and do you have to add the commands to each row or can you just use inline editing and the toolbar? 

Live Chat Icon For mobile
Up arrow icon