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

Datamanager keep editurl after executequery updates datasource (json)

I'm working with an editable grid that will be reloaded after a user changes the value of a dropdown. The grid needs to be edited, and is currently working correctly after first load. However when I change the dropdown and update the datasource, the editurl functionality stops working (doesn't call the server controller).

My grid definition:
                    .Datasource(ds => ds.URL("../Grid/OpenedDataSource").UpdateURL("../Grid/OpenedUpdate").BatchURL("../Grid/OpenedBatchUpdate").Adaptor(AdaptorType.UrlAdaptor))
                    .Query("new ej.Query().addParams('statementID'," + Model.StatementNameID.ID + ")")
                    .EditSettings(edit => { edit.AllowEditing(); })//.EditMode(EditMode.Batch); })
                    .FilterSettings(filter => { filter.FilterType(FilterType.Menu); })
                    .ScrollSettings(col => { col.Height("45%"); })
                    .ToolbarSettings(toolBar => toolBar.ShowToolbar().ToolbarItems(items =>
                    .Mappers(map => map.ExportToExcelAction("../Grid/StatementItemsExportToExcel"))
                    .Columns(columns =>
                        columns.Field(p => p.LineID).Visible(false).ShowInColumnChooser(false).IsPrimaryKey(true).Add();
                        columns.Field(p => p.LineName).AllowEditing(false).AllowFiltering(false).HeaderText("Line").Width(150).Width(180).ShowInColumnChooser(false).IsFrozen(true).Add();
                        columns.Field(p => p.Jan).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Feb).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Mar).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Apr).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.May).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Jun).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Jul).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Aug).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Sep).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Oct).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Nov).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.Dec).Format("{0:n}").AllowFiltering(false).ShowInColumnChooser(false).Add();
                        columns.Field(p => p.FY).Format("{0:n}").AllowEditing(false).AllowFiltering(false).Add();
                        columns.Field(p => p.C1st).HeaderText("1st. Qtr").AllowEditing(false).Format("{0:n}").AllowFiltering(false).CssClass("bg-info").Visible(false).Add();
                        columns.Field(p => p.C2nd).HeaderText("2nd. Qtr").AllowEditing(false).Format("{0:n}").AllowFiltering(false).CssClass("bg-info").Visible(false).Add();
                        columns.Field(p => p.C3rd).HeaderText("3rd. Qtr").AllowEditing(false).Format("{0:n}").AllowFiltering(false).CssClass("bg-info").Visible(false).Add();
                        columns.Field(p => p.C4th).HeaderText("4th. Qtr").AllowEditing(false).Format("{0:n}").AllowFiltering(false).CssClass("bg-info").Visible(false).Add();
                        columns.Field(p => p.YTD).Format("{0:n}").AllowEditing(false).AllowFiltering(false).Visible(false).CssClass("bg-info").Add();
                        columns.Field(p => p.LineTypeID).HeaderText("Type").ShowInColumnChooser(false).Visible(false).Add();
                        columns.Field(p => p.Computed).HeaderText("Type").ShowInColumnChooser(false).Visible(false).Add();

                    .SortSettings(sort => sort.SortedColumns(col => col.Field("LineID").Direction(SortOrder.Ascending).Add()))
                    .ClientSideEvents(eve => eve.QueryCellInfo("querycellinfo").ToolbarClick("OnToolbarClick").BeginEdit("beginEdit").CellEdit("cellEdit").DataBound("gridDatabound"))


The function that gets called by the dropdown change:

function changeScenario(args) {

        var ddlMonth = $("#selectMonth").data("ejDropDownList");
        var ddlYear = $("#selectYear").data("ejDropDownList");
        var obj = $("#Grid").ejGrid("instance");

        var statementID = ddlMonth.getSelectedValue();
        var query = new ej.Query().addParams("selectedStatementID", statementID);

        query.addParams("selectedStatemenTitle", ddlMonth.selectedTextValue);

        //Check if there if Year Drop down is defined and add parameter
        if (typeof ddlYear != 'undefined')
            query.addParams("selectedYear", ddlYear.selectedTextValue);
            query.addParams("selectedYear", null);

        //Creating ejDataManager with UrlAdaptor        
        var dm = ej.DataManager({ url: "../Grid/StatementDataSourceStatementID", adaptor: new ej.UrlAdaptor() });
        var promise = dm.executeQuery(query);
        promise.done(function (e) {

            //Assign the result to the grid dataSource using "dataSource" method.            
            var title = e.result.title;
            var month = title.charAt(title.indexOf("-") + 2);

I have attempted modifying the promise.done(function) to refresh the data manager as follows, but still I wouldn't either load the correct grid in the next change, or it would not call the update url.
Attempted modifications: 

promise.done(function (e) {

            //Assign the result to the grid dataSource using "dataSource" method.            
            var title = e.result.title;
            var month = title.charAt(title.indexOf("-") + 2);
            //Assign the datasource and update urls
            var dmAndData = ej.DataManager({ url: "../Grid/OpenedDataSource", updateUrl: "../Grid/OpenedUpdate", adaptor: new ej.UrlAdaptor() });
            var id = $(':hidden#statenemtID').val();            
            obj.model.query = new ej.Query().addParams("statementID", id); // .Query("new ej.Query().addParams('statementID'," + Model.StatementNameID.ID + ")")
promise.done(function (e) {

            //Assign the result to the grid dataSource using "dataSource" method.            
            var title = e.result.title;
            var month = title.charAt(title.indexOf("-") + 2);
            //Assign the datasource and update urls
            var dmAndData = ej.DataManager({ json: e.result.result, url:"../Grid/OpenedDataSource", updateUrl: "../Grid/OpenedUpdate", adaptor: new ej.remoteSaveAdaptor() });

5 Replies

RU Ragavee U S Syncfusion Team January 20, 2017 05:50 AM UTC

Hi Luis,  

Thanks for your interest in Syncfusion products.  

The UpdateURL property of the DataManager will not be triggered when the editMode is batch. The corresponding property of the DataManager for “batch” editMode is BatchURL.

Since the batch edit functionality performs the CRUD operation as a whole; all the added, edited, deleted record details will be passed to the server as list of records. The InsertURL, UpdateURL and RemoveURL properties will not be triggered as on performing CRUD operations in grid it will be locally saved in grid and only on clicking the update icon in grid toolbar, a post action with all the batch changes will be triggered which is handled using BatchURL property.

The Server-Side function is declared with the following parameters for editing functionality.

Parameters Table   
Parameter Name   
Batch Add   
public ActionResult BatchUpdate(List<Orders> changed, List<Orders> added, List<Orders> deleted){}   
Batch Update   
Batch Delete   

Please refer to the below documentation for more information.   

Ragavee U S.  

LJ Luis Javier Almazan Emery January 20, 2017 03:31 PM UTC

Hi, current editmode is "normal". editmode.batch is commented in the code. See attached image in zip.

Attachment: EditMode_6e36ae4a.7z

RU Ragavee U S Syncfusion Team January 23, 2017 02:35 PM UTC

Hi Luis, 

We are sorry but the issue is not reproduced at our end. We have prepared a sample in v14.4.015 such that the dataSource of the Grid is updated on the change event of the external dropdownlist, which can be downloaded from the below location. 

Please try the above sample and if you still face any difficulties, share the following details. 

1.       Product version details. 
2.       Network tab of the developer tool showing the post failure. 
3.       Video demo of the issue. 
4.       If any script error thrown while saving the grid data, please share the screenshot of the stack trace of the error. 
5.       If possible, please reproduce the issue in the above provided sample and share. 

Ragavee U S. 

SC Scott September 30, 2017 07:45 PM UTC

I am using Syncfusion.EJ.MVC Version 15.2500.040 (Runtime Version v4.0.30319)

I am having effectively the same problem.  I have a Grid where I allow Edit via a RemoteSaveAdapater as shown below:


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



               // .AllowPaging()

               .EditSettings(edit => { edit.AllowAdding().AllowDeleting().AllowEditing().EditMode(EditMode.DialogTemplate).DialogEditorTemplateID("#template"); })

                   .ToolbarSettings(toolbar =>


                       toolbar.ShowToolbar().ToolbarItems(items =>











            .PageSettings(page => page.PageSize(15))





            .FilterSettings(filter => { filter.FilterType(FilterType.Excel); })

        // .AllowFiltering()


        // .EnableResponsiveRow(true)

        .Columns(col =>














The grid uses a Dialog Editor template where like Luis, it works somewhat reliabily on the first load of the view.  In other words if I go to the View and I edit record #1, I can see the controller method being called, and data being handled on the server etc. However, if I attempt to edit the same record a second time, the controller action is never called.  I likewise don't see any errors on the client (browser debugging tools), which leaves me with little I can troubleshoot.  

Please advise!

MS Mani Sankar Durai Syncfusion Team October 2, 2017 05:35 AM UTC

Hi Scott, 

We have analyzed your query and we are not able to reproduce the reported issue.  We have also prepared a sample based on the code example given and that can be downloaded from the below link 
We have also checked the continuous editing for the same and also for the different row. 
If you still face the issue please get back to us with the following details, 
1.       Share the screenshot of the issue.  
2.       Share the screenshot of how the post has been processing in network tab and what is response from that. 
3.       Share the controller page. 
4.       Share the hosted site. 
5.       If possible please reproduce the issue in the above attached sample. 
The provided information will help us to analyze the issue and provide you the response as early as possible. 

Manisankar Durai. 

Live Chat Icon For mobile
Up arrow icon