Drag & Drop in datagrid.

[Neelesh2007]

Hi to all.
I m having project with VB6.0 as front End and Access-2003 as backend. In one of my code I m having Datagrid with ADODC as datasource. I want Drag & Drop Functionality in Datagrid as like in Excel so that I can paste value in to other rows just by drag & Drop.
Is it possible?

Thanks.

[Neelesh2007]

Hi all,
Please pass comments that is it possible or not? if posible give me hint or some sample code.

thanx.
Neelesh

[Neelesh2007]

My problem is still unsolved. Can anybody guide me?
Thanks
Neelesh

[Killer42]

My problem is still unsolved. Can anybody guide me?

Wow, impatient aren't you! ;)

Seriously, sorry you don't seem to have had a response to this in nearly two months.

Can you provide a bit more detail on exactly how you want the drag and drop to work, from the user's point of view?

For instance, are we talking about dragging a single cell, or what? And when you mention Excel, are you talking about dropping things from elsewhere onto Excel, or grabbing the corner of a cell and dragging it to fill a range? Or something else entirely?

[Neelesh2007]

Actually I want to grab the value of a Particular Cell in Datagrid and Fill this value in succeeding cells of Datagrid in Particular column by Dragging these Cells.
e.g. suppose in column 5 of my datagrid 8th Row contains Value Baroda, I want to grab these value "Baroda" and I want to Fill This value in Succeeding Rows in Same column by Dragging mouse over the Rows.
I hope you get me.
Thanks
Neelesh

[Neelesh2007]

My Question is still unanswered.

Neelesh

[Killer42]

Since nobody else seems to be showing any interest, for some reason...

I've been having a quick browse of the events for the DataGrid control, and it doesn't look very promising. It seems to be designed mainly to work with an individual "current" record, while you really want to drag from record to record. In other words, you want to treat it as a "real" grid, similar to a spreadsheet, while MS didn't really design it that way.

Perhaps you will need to do something like tracking events such as MouseDown and ColRowChange (or SelChange), and copying values to/from the grid at appropriate times.