Hi David,

     When you set paging mode to classic paging and paging size to 20, it will load the data per page. For your issue, after further investigation, here is what you might can do. On our property, you can go to Layout Setting - PagingDataRetrievalMode, set them to ReturnPartialRows. 

      I hope it helps and please, do not hesitate to ask if you have any other questions. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi Jocelyn,

    Here is a new snippet. Hopefully it will meet your scenario. If i am not mistaken, you want to set the value back to its original before the value goes to BatchUpDate. The problem is occurred because we are using BatchUpdate, it will hold the value first and all the changes will be made when we accept all changes. So, eventhough we set value to the old value, it will not change if the accept is not be made.

function WebGrid1_OnEndRowEditing(controlId, row)
        {
            var controlId = ISGetObject("WebGrid1");
            var maxValue = 10;


            if (row.GetCells().GetNamedItem("UnitPrice").Get("Value") > maxValue)
            {
                row.GetCells().GetNamedItem("UnitPrice").SetValue(row.GetCells().GetNamedItem("UnitPrice").Get("OldValue"), true);
                controlId.AcceptAllChanges();

            }
            else
            {
                row.GetCells().GetNamedItem("UnitPrice").SetValue(row.GetCells().GetNamedItem("UnitPrice").Get("Value"), true);
            }

            return true;
        }

       I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi Kevin,

     Thank you for using our community forum. Yes, we do have a MySQL database binding to WebScheduler using ISDataSource. If you open our WebScheduler sample, there is a sample using MySQL database, for instance MoveSQL.aspx. Or perhaps, you can see our walkthrough on our documentation at "ms-help://ISNet.WebUI.WebScheduler.V3/ISNet.WebUI.WebScheduler/Binding SQL database to WebScheduler using ISDataSource.html" 

     I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi Xedem,

     I am still unable to replicate the issue. Here is the link of my video showing of what the WebGrid is capable to. The grouping and sorting seems to be working just fine. I am wondering where was I missing, perhaps you can show me on how to reproduce the issue. 

     I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi Jocelyn

     Could you kindly find and run my attached sample? It is using Product Northwind database. In there, you can the unit price value. It will be invalid if you insert the value is greater than 10. And could you tell me if it  gives you a same result with your project ? 

     Thank you and have a nice day.

Best Regards,

Andi Santoso