[VB] - ListView Drag and Drop - Tilted Forum Project Discussion Community

11-19-2004, 02:09 PM

I've got 3 database tables:
accounts
groups
links

accounts and groups both store top-level header information. The links table links the accounts into the groups on a many to many basis.

So what I want is for the user to see which accounts are in which groups(done), and also for them to drag the accounts from one group to another.

I've set up a form with a TreeView displaying the groups. Clicking on a node loads the attached accounts into a ListView.

I've got a second pair of TreeView and ListView controls underneath. What I want to do is to let the user drag an account from the top view and drop it into whatever group they want on the bottom view (or vice-versa). Of course, I need to perform all the appropriate sql to edit/add rows into my links table, but it's the actual implementation of the Dragging and Dropping that I can't seem to get my head around.

Has anyone done anything like this who can give me some tips?

11-19-2004, 05:26 PM

Ahh it's ok, I figured it out - I used the OLEStartDrag and OLECompleteDrag events.
First I stored the indexes of the selected data in a global variable, and then sent it back in on the CompleteDrag event.

11-19-2004, 02:09 PM	#1 (permalink)
zen_tom Guest	[VB] - ListView Drag and Drop I've got 3 database tables: accounts groups links accounts and groups both store top-level header information. The links table links the accounts into the groups on a many to many basis. So what I want is for the user to see which accounts are in which groups(done), and also for them to drag the accounts from one group to another. I've set up a form with a TreeView displaying the groups. Clicking on a node loads the attached accounts into a ListView. I've got a second pair of TreeView and ListView controls underneath. What I want to do is to let the user drag an account from the top view and drop it into whatever group they want on the bottom view (or vice-versa). Of course, I need to perform all the appropriate sql to edit/add rows into my links table, but it's the actual implementation of the Dragging and Dropping that I can't seem to get my head around. Has anyone done anything like this who can give me some tips?

11-19-2004, 05:26 PM	#2 (permalink)
zen_tom Guest	Ahh it's ok, I figured it out - I used the OLEStartDrag and OLECompleteDrag events. First I stored the indexes of the selected data in a global variable, and then sent it back in on the CompleteDrag event.