Move Row from one datagrid to another

[JohnnyLong]

I have a form with 3 tabs. Tab1 has a datagrid displaying candidate details. I want to right click a row and using the contextmenu click Shortlist to move the selected row to a datagrid on Tab2 and click Reject to move the selected row to a datagrid on Tab3. How would you go about this? I'm thinking of adding a column to my sql7 searchresults table, 'Selection char(1)'. Then update the record with 'O' for original list, 'S' for shortlist and 'R' for reject list, and then bind each datagrid to the records with the corresponding 'Selection'.
Or is there a way to move rows between grids and then save the data to the table?

TIA

John

 

[ThatRickGuy]

If you have underlying datatable for each datagrid you can use the datatable.importrow(datarow) method to do so.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.