Grid Drag Drop with datatable using sqldatasource

[Syed M Ali Shah]

hi,

I have to reorder items in the radgrid by using drag and drop. A solution provided in exisiting forum thread was using data tables. I can reorder items but this is only temporarily. As all the processing is done in data table. What i want is when my data is updated in data table it should be updated in actual database from where i am getting the data (through sqldatasource). I am using a c# version. Please help in it. I will be very thankful.

Cheers, Ali

[Mira]

Hello Syed,

In our online demo the grids are bound to lists which are updated on RowDrop. In your case I recommend that you bind the grids to SqlDataSources and execute SQL queries to update the database in the RowDrop event handler.

Best wishes,
Mira
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Heath Brown]

Can you give a SQL query example of how this might look?

[Sebastian]

Hi Heath,

Sample implementation can be found in this section of our code library:
http://www.telerik.com/community/code-library/aspnet-ajax/grid/radgrid-items-reorder-using-db-backend.aspx

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.