[Solved] Two Grids - DoubleClick Row To Insert

[Heath Brown]

Hello,

I'm a new customer who just purchased the controls today and am very excited.  I'm working on a little project and I need some help.

I have two radgrids on my page which are both populated by a different table in an SQLDataSource.  I want to be able to doubleclick on a row in table one to be able to insert the row just doubleclicked into the second grid's table (using a database insert).  I've already got drag and drop working (which functions the same way but allows them to drag the row from table 1 to table 2).  Is this possible and if so, can someone give me an example?

OR

Would it be easier if I had a clientselect column with checkboxes and a button in the commanditems (with a custom template) that is labeled "Add Selected Topics" and when pressed it would take any topics that are selected in grid 1 and insert them as new records into grid 2?  If I used this method I might completely remove drag and drop.  I had this version working as far as the grid and selecting items, but I couldn't figure out how to insert the selected items into the other grid's database table.  Bear with me though, I'll get better at this! :)

[Heath Brown]

Help!  Even if its just a link to an article that might help. :)

[Thomas Salt]

This may help.

http://www.telerik.com/help/aspnet-ajax/grdgettingfamiliarwithclientapi.html

[Heath Brown]

This does help quite a bit.  I'll see if I can figure out the rest.  Thanks for the clue!

[Princy]

Hi Heath,

I found the following forum link which discussses on a similar case as yours wherein a solution mentioned was to disable the drag and drop feature in the grid, but instead have the control postback upon checking/unchecking the checkboxes, then insert the selected row details to the second grid's datasource and then bind the grid. Here's the link:
GRID ROW COPY FROM ONE GRID TO ANOTHER 

-Princy.

[Heath Brown]

Thanks for the help everyone.  I'm still trying to figure out the best way to do this.  I might be using a RadListbox control instead.  I posted a question on the Listbox forum about 2 listboxes.  I have everything working the way I want now - except the insert.

P.S.  This Telerik community and Telerik itself is awesome.  I've been able to do some great work with these controls and I really appreciate both the community's help and the developers for making this great product.