Retrieving values from multiple rows selected in a datagrid

[Takis]

I managed to retrieve only one value of the first of the selected rows of a datagrid and copy it to the clipboard using the following line:

Clipboard.SetDataObject(DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, 15), False)

but how can i retrieve values from all the rows selected at once?

Thanks

 

[jonbatts]

Once you have the rows selected just use one line of code

SendKeys.Send("^c")

It will simulate pressing Control-C and thus copy whatever's selected.

 

[Takis]

the sendkeys.send does not seem appropriate to me!
As i understand i must use the
Clipboard.SetDataObject(DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, 15), False)
in combination with an array that will keep all of the values that i want to copy

 

[KnotGoblin]

i don't know much about the clipboard. i guess the regular clipboard will only contain one object at a time. however the Microsoft Office clipboard can contain mulitple objects.

So maybe consider using the Office clipboard.

or concatenate the rows into a string (or some datatype) and copy that to the system clipboard.

just a suggestion.

-Jer