Permalink
Fetching contributors…
Cannot retrieve contributors at this time
57 lines (45 sloc) 4.26 KB
title ms.custom ms.date ms.prod ms.reviewer ms.suite ms.technology ms.tgt_pltfrm ms.topic dev_langs helpviewer_keywords ms.assetid caps.latest.revision author ms.author manager
How to: Enable Users to Copy Multiple Cells to the Clipboard from the Windows Forms DataGridView Control
03/30/2017
.net-framework
dotnet-winforms
article
jsharp
cells, copying to Clipboard
DataGridView control [Windows Forms], copying multiple cells
data grids, copying multiple cells
Clipboard, copying multiple cells
fd0403b2-d0e3-4ae0-839c-0f737e1eb4a9
14
dotnet-bot
dotnetcontent
wpickett

How to: Enable Users to Copy Multiple Cells to the Clipboard from the Windows Forms DataGridView Control

When you enable cell copying, you make the data in your xref:System.Windows.Forms.DataGridView control easily accessible to other applications through the xref:System.Windows.Forms.Clipboard. The values of the selected cells are converted to strings and added to the Clipboard as tab-delimited text values for pasting into applications like Notepad and Excel, and as an HTML-formatted table for pasting into applications like Word.

You can configure cell copying to copy cell values only, to include row and column header text in the Clipboard data, or to include header text only when users select entire rows or columns.

Depending on the selection mode, users can select multiple disconnected groups of cells. When a user copies cells to the Clipboard, rows and columns with no selected cells are not copied. All other rows or columns become rows and columns in the table of data copied to the Clipboard. Unselected cells in these rows or columns are copied as blank placeholders to the Clipboard.

To enable cell copying

Example

The following complete code example demonstrates how cells are copied to the Clipboard. This example includes a button that copies the selected cells to the Clipboard using the xref:System.Windows.Forms.DataGridView.GetClipboardContent%2A?displayProperty=nameWithType method and displays the Clipboard contents in a text box.

[!code-csharpSystem.Windows.Forms.DataGridViewClipboardDemo#00] [!code-vbSystem.Windows.Forms.DataGridViewClipboardDemo#00]

Compiling the Code

This code requires:

  • References to the N:System and N:System.Windows.Forms assemblies.

For information about building this example from the command line for [!INCLUDEvbprvb] or [!INCLUDEcsprcs], see Building from the Command Line or Command-line Building With csc.exe. You can also build this example in [!INCLUDEvsprvs] by pasting the code into a new project. Also see How to: Compile and Run a Complete Windows Forms Code Example Using Visual Studio.

See Also

xref:System.Windows.Forms.DataGridView
xref:System.Windows.Forms.DataGridView.ClipboardCopyMode%2A
xref:System.Windows.Forms.DataGridView.GetClipboardContent%2A
Selection and Clipboard Use with the Windows Forms DataGridView Control