Add and Edit not updating database
Hi Brian Collings,
Greetings from Syncfusion support.
Query: Add and Edit not updating database
Based on the information you've provided, it's clear that you're currently rendering the Grid using local data. However, it's important to note that any modifications made to the grid's dataSource won't automatically synchronize with the database when using local data. Based on the code example you shared, it seems that you intend to transmit newly added or edited data to the server for storage in the database.
To address this requirement, we highly recommend adopting the UrlAdaptor remote data service. By leveraging the UrlAdaptor, you'll have the capability to perform a variety of server-side actions, including adding, editing, deleting, filtering, sorting, paging, and more. This approach empowers you to interact with the server to manage data changes effectively, ensuring that the changes you make to the grid's data are synchronized with the database accurately.
For more information, please refer to the below code example, screenshot, documentation, and attached sample.
|
[Views\Home\Index.cshtml]
<div id="Grid"></div> <script> var data = new ej.data.DataManager({ url: '/Home/UrlDatasource', insertUrl: '/Home/Insert', updateUrl: '/Home/Update', removeUrl: '/Home/Remove', adaptor: new ej.data.UrlAdaptor() }); var grid = new ej.grids.Grid({ dataSource: data, allowSorting: true, columns: [ { field: 'OrderID', headerText: 'Order ID', isPrimaryKey: true }, { field: 'CustomerID', headerText: 'Customer ID', validationRules: { required: true } }, { field: 'Freight', headerText: 'Freight', width: '150', textAlign: 'Center', validationRules: { required: true, number: true } }, { field: 'OrderDate', headerText: 'Order Date', width: '220', type: 'datetime', format: 'yyyy/MM/dd hh:mm', editType: 'datetimepickeredit', visible: true } ], height: 350, editSettings: { allowAdding: true, allowEditing: true, allowDeleting: true, mode: 'Dialog' }, toolbar: [ 'Add', 'Edit', 'Delete', 'Search' ], allowPaging: true, pageSettings: { pageCount: 2, pageSizes: true }, }); grid.appendTo('#Grid'); </script>
[Controllers\HomeController.cs]
public ActionResult UrlDatasource(TestDm dm) { IEnumerable DataSource = orddata.ToList(); DataOperations operation = new DataOperations();
if (dm.Search != null && dm.Search.Count > 0) { DataSource = operation.PerformSearching(DataSource, dm.Search); //Search } if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting { DataSource = operation.PerformSorting(DataSource, dm.Sorted); } if (dm.Where != null && dm.Where.Count > 0) //Filtering { DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator); } int count = DataSource.Cast<OrdersDetails>().Count(); if (dm.Skip != 0) { DataSource = operation.PerformSkip(DataSource, dm.Skip); //Paging } if (dm.Take != 0) { DataSource = operation.PerformTake(DataSource, dm.Take); } return dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource); } public ActionResult Update(CRUDModel<OrdersDetails> myObject) { // Update the data var ord = myObject; OrdersDetails val = orddata.Where(or => or.OrderID == ord.Value.OrderID).FirstOrDefault(); if (val != null) { val.OrderID = ord.Value.OrderID; val.EmployeeID = ord.Value.EmployeeID; val.CustomerID = ord.Value.CustomerID; val.Freight = ord.Value.Freight; val.OrderDate = ord.Value.OrderDate; val.ShipCity = ord.Value.ShipCity; val.ShipAddress = ord.Value.ShipAddress; val.ShippedDate = ord.Value.ShippedDate; }
return Json(ord.Value);
} public ActionResult Insert(OrdersDetails value) { // Insert the data var ord = value; orddata.Insert(0, ord); return Json(value); } public void Remove(int key) { // Remove the data orddata.Remove(orddata.Where(or => or.OrderID == key).FirstOrDefault()); } |
Url adaptor: https://ej2.syncfusion.com/javascript/documentation/data/adaptors#url-adaptor
Please feel free to contact us if you require any further assistance. We are always available and eager to help you in any way we can.
Regards,
Hemanth Kumar S
Attachment: 3320111498785947_e523b66e.zip
Hi Brian,
You have Mark as answer option below each reply.
Once you Marked Answered. It’s will show like below.
