I want to perform CRUD operations in the grid. I want to do individual updates and do not want to commit the grid on client side until the CRUD operations have taken place in the database successfully. So when deleting a row in the grid
$('body').on('iggridupdatingrowdeleted', '#grid', function () {
$('#grid').igGrid("saveChanges")
if (SuccessfulUpdate)
{
$('#grid').igGrid("commit");
}
else
// Do not commit
});
How can I check for successful DB update here?
Hello,
Thank you for getting back to me.
I created a small sample illustrating your scenario and I am attaching it for your reference. In my sample I have an igGrid with remote data source set via dataSourceUrl property the and Updating feature enabled. I am editing a row and I am calling saveChanges method by clicking Save Changes button. I set the success in the response to false in order to hit the error callback of the saveChanges method. In this handler I am calling dataBind and on my side the grid is successfully bound to its initial data source. For example:
<script> $(function () { $("#btn").click(function () { $("#grid1").igGrid("saveChanges", function (data) { alert("Changes were saved successfully") }, function (jqXHR, textStatus, errorThrown) { alert("An error occurred while saving the changes. Error details: " + textStatus); $("#grid1").igGrid("dataBind"); }); }); }); </script>
Could you please test this sample on your side and let me know what is the result. Additionally, if this is not an accurate demonstration of what you are trying to achieve please feel free to modify it and send it back to me for further investigation along with steps to reproduce.
Vasya - Thanks for clarifying this. The sorting behavior DID stop working. So I am trying to implement it the way you explained above. i.e.
- Commit the changes,
- and, handle the saveChanges() success and error Callback.
when handling error callback, I am trying to rebind the grid (to rollback the changes that were committed before calling "saveChanges" method), but the grid does not rebind. I am using MVC Helper in my view. In order to refresh the grid, would I have to define a datasource on client side?
Hello Anonymous,
In general the better practice is to commit local changes before sending them to the server, however, in your particular case your code will work correctly. Please keep in mind that the presence of local changes prevent operations working on the dataView like Sorting and Paging from executing.
Please let me know if you have any additional questions or concerns regarding this matter.
Vasya - My solution above seem to be working (i.e. I am able to save, delete rows before it commits at the client side; the changes happen on one row at a time and the transaction row clears up after each CRUD operation) but it totally contradicts to what you are telling us above. I want to make sure I am doing this the correct way to avoid any bigger problem in later stages of development.
In order to send all the transactions to the server with the AJAX request they should be first committed on the client and afterwards with saveChanges method send to the server. If changes are not committed on the client they are not added to the transactions collection and respectively they can not be send to the server and saved in the underlying data base
Please let me know if you have any additional questions regarding this matter.