This is a migrated thread and some comments may be shown as answers.

Grid Drag Drop with datatable using sqldatasource

3 Answers 142 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Syed M Ali Shah
Top achievements
Rank 1
Syed M Ali Shah asked on 18 Aug 2009, 03:00 AM
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

3 Answers, 1 is accepted

Sort by
0
Mira
Telerik team
answered on 20 Aug 2009, 09:20 AM
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.
0
Heath Brown
Top achievements
Rank 1
answered on 08 Oct 2009, 03:59 AM
Can you give a SQL query example of how this might look?
0
Sebastian
Telerik team
answered on 08 Oct 2009, 08:20 AM
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.
Tags
Grid
Asked by
Syed M Ali Shah
Top achievements
Rank 1
Answers by
Mira
Telerik team
Heath Brown
Top achievements
Rank 1
Sebastian
Telerik team
Share this question
or