RowDrop using OpenAccessDataSource

[Jaimie]

How can i achieve reording in RowDrop function if the RadGrid is using OpenAccessDataSource as the datasource?

I implemented reorder items code in RowDrop using normal SQL update statement. The SQL update statement passed all checking and retured true for the update process. Howevever, it seems the order in the database doesn't change at all and the RadGrid.Rebind() returns the same order as before. 

Can anyone help me out?

Thanks

[Jaimie]

Anyone?

[Sebastian]

Hi Jaimie,

You can use the sample project from the code library entry linked below as a starting point:
http://www.telerik.com/community/code-library/aspnet-ajax/grid/radgrid-items-reorder-using-db-backend.aspx 

If you follow the idea to update the order of the underlying rows and rebind the grid afterwards, using OpenAccessDataSource for grid item generator should not make any conceptual difference.

Best regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Felipe de Jesús]

Greetings.

How i can add a confirmation after release the row? If i confirm, then execute the update procedure, if not, cancel the row change.

Kind regards.