I have this issue, and i'm trying to deal with it for the last 3 days now, no solution found.
My grid is loaded using an DataAdapter.
When I edit the items in the grid,and fire the update command, the data in my database will not be updated.
This is until i move the grid one row. Then it will accept changes made. So i'm struggeling here to find a way out.
Could you please provide me some sample or solution for this?
Btw, i'm using VB.NET for this.
17 Answers, 1 is accepted
I haven't heard of this situation before to be honest. It sounds very strange. If you could post some code to replicate it, I'll have a look at it first thing for you. In the meantime, I'd suggest wrapping any updates to your grid in
this may hep, but without seeing an example, it may be tricky to sort out.
Witch works fine for me. Expect that i always need to change a row before it updates.
I'm used to working with the VB.NET Datagridview, where this code always did the job like i wanted it to be.
Thank you for your help.
Are yous still in edit mode while pressing the save button?
Try calling an EndEdit() or if this failes, try adding a BeginUpdate(); EndUpdate(true) in the first lines of your ButtonClick.
Please let me know if this works for you.
Telerik WinForms MVP
Yes, i tryed all of those options, none of them seem to work.
It seems that for some reason the editor only exits when i move a row.
Whatever i try, it wont let me update without moving a row.
So it is because the grid is still editing, can you please create a very small project, copy paste here and i will help you solve this problem.
Telerik WinForms MVP
This is my designer file
And here is my code:
There is a DataSet3 included, but is not used at all.
When i try the same thing with a REGULAR DataGridView, i use this code:
And it's working the way it should be working.
So i cant figure it out at all...
Thank you for your time
Sorry about the delay in getting back to you. I haven't been able to run your project at the moment, but may I suggest
- Disable your button
- Subscribe to the CellEndEdit event.
- In there, re-enable your button and give it a click (removing the
Let me know if that helps at all.
Tried that allready, doesnt helps...
This sounds very odd. After you update, please can you also try calling
We have never expienced this issue before, but I don't have any DB access today as I'm at home so can't try it. Let me know if this help.
I will try to adapt me to that then
In this scenario the edit operation depends on the bound object that in your case is DataTable/DataSet. DataRow/DataRowView objects implement IEditableObject and when some data in RadGridView is changed, the internal CurrencyManager calls EndEdit of current item after the current position is changed to another row.
If you want to apply your changes immediately, you can use following code snippet:
I hope this helps.
the Telerik team
I faced with sam problem as you. Have you figured out how to fixit?
Thank you for writing.
We have a documentation article providing examples how the database can be updated handling various scenarios: https://feedback.telerik.com/Project/154/Feedback/Details/203285-fix-radgridview-the-last-row-is-not-updated-when-the-grid-is-bound-to-ieditabl.
In case you are using an older version of the controls you can check the following feedback item. The issue was resolved in the R3 2016 SP1 version of the suite.
I hope this helps. Should you have further questions please do not hesitate to write back.
Telerik by Progress
dgErrors.CurrentCell = Nothing
this worked for me, though i didnt try any of the other suggestions.
It effectively moves your selected row , and the problems goes away
Thank you for updating the thread and for sharing your solution. I hope that it will help the community.