Click here to Skip to main content
13,597,064 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


18 bookmarked
Posted 8 Jun 2011
Licenced CPOL

Copy Paste in Datagridview Control

, 8 Jun 2011
Rate this:
Please Sign up or sign in to vote.
How to copy paste in Datagridview control


This post discusses how to add a datagridview and a contextmenustrip with cut, copy and paste into the form.

Image 1

Populate the DataGridView and define the click events as follows:

private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
    if (dataGridView1.SelectedCells.Count > 0)
        dataGridView1.ContextMenuStrip = contextMenuStrip1;

private void cutToolStripMenuItem_Click(object sender, EventArgs e)
    //Copy to clipboard

    //Clear selected cells
    foreach (DataGridViewCell dgvCell in dataGridView1.SelectedCells)
        dgvCell.Value = string.Empty;

private void copyToolStripMenuItem_Click(object sender, EventArgs e)

private void pasteToolStripMenuItem_Click(object sender, EventArgs e)
    //Perform paste Operation

Copy/Paste routines follow...

The clipboard values are saved in a Dictionary, so the user can validate or manipulate the values before assigning them into gridviewcell.

private void CopyToClipboard()
    //Copy to clipboard
    DataObject dataObj = dataGridView1.GetClipboardContent();
    if (dataObj != null)

private void PasteClipboardValue()
    //Show Error if no cell is selected
    if (dataGridView1.SelectedCells.Count == 0)
        MessageBox.Show("Please select a cell", "Paste", 
		MessageBoxButtons.OK, MessageBoxIcon.Warning);

    //Get the starting Cell
    DataGridViewCell startCell = GetStartCell(dataGridView1);
    //Get the clipboard value in a dictionary
    Dictionary<int, Dictionary<int, string>> cbValue = 

    int iRowIndex = startCell.RowIndex;
    foreach (int rowKey in cbValue.Keys)
        int iColIndex = startCell.ColumnIndex;
        foreach (int cellKey in cbValue[rowKey].Keys)
            //Check if the index is within the limit
            if (iColIndex <= dataGridView1.Columns.Count - 1
            && iRowIndex <= dataGridView1.Rows.Count - 1)
                DataGridViewCell cell = dataGridView1[iColIndex, iRowIndex];

                //Copy to selected cells if 'chkPasteToSelectedCells' is checked
                if ((chkPasteToSelectedCells.Checked && cell.Selected) ||
                    cell.Value = cbValue[rowKey][cellKey];

private DataGridViewCell GetStartCell(DataGridView dgView)
    //get the smallest row,column index
    if (dgView.SelectedCells.Count == 0)
        return null;

    int rowIndex = dgView.Rows.Count - 1;
    int colIndex = dgView.Columns.Count - 1;

    foreach (DataGridViewCell dgvCell in dgView.SelectedCells)
        if (dgvCell.RowIndex < rowIndex)
            rowIndex = dgvCell.RowIndex;
        if (dgvCell.ColumnIndex < colIndex)
            colIndex = dgvCell.ColumnIndex;

    return dgView[colIndex, rowIndex];

private Dictionary<int, Dictionary<int, string>> ClipBoardValues(string clipboardValue)
    Dictionary<int, Dictionary<int, string>>
    copyValues = new Dictionary<int, Dictionary<int, string>>();

    String[] lines = clipboardValue.Split('\n');

    for (int i = 0; i <= lines.Length - 1; i++)
        copyValues[i] = new Dictionary<int, string>();
        String[] lineContent = lines[i].Split('\t');

        //if an empty cell value copied, then set the dictionary with an empty string
        //else Set value to dictionary
        if (lineContent.Length == 0)
            copyValues[i][0] = string.Empty;
            for (int j = 0; j <= lineContent.Length - 1; j++)
                copyValues[i][j] = lineContent[j];
    return copyValues;


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Balu Sathish
Software Developer UVJ Technologies
India India
No Biography provided

You may also be interested in...


Comments and Discussions

QuestionchkPasteToSelectedCells Pin
n shiva Ram24-Sep-14 2:02
membern shiva Ram24-Sep-14 2:02 
QuestionExcellent thanks. Used this with derived DataGridView class. Pin
Member 1062780723-Jul-14 5:02
memberMember 1062780723-Jul-14 5:02 
QuestionIs it possible to Force Single Cell Only Pin
Member 171591218-Feb-14 1:32
memberMember 171591218-Feb-14 1:32 
GeneralThanks Pin
Mikles Max29-Apr-13 14:45
memberMikles Max29-Apr-13 14:45 
Questionconvert to Pin
mr.fugio29-Nov-12 19:57
membermr.fugio29-Nov-12 19:57 
AnswerRe: convert to Pin
Michael Paschal25-Mar-15 14:25
memberMichael Paschal25-Mar-15 14:25 
Question...? Pin
Member 92618739-Aug-12 23:49
memberMember 92618739-Aug-12 23:49 
AnswerRe: ...? Pin
rndtech15-Jul-13 13:20
memberrndtech15-Jul-13 13:20 
GeneralGreat Code Pin
HolyHannah21-Jun-12 3:27
memberHolyHannah21-Jun-12 3:27 
GeneralMy vote of 5 Pin
manoj kumar choubey5-Apr-12 7:53
membermanoj kumar choubey5-Apr-12 7:53 
QuestionCopy and Paste Pin
Anthony Fonseca5-Jul-11 16:20
memberAnthony Fonseca5-Jul-11 16:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web01-2016 | 2.8.180621.3 | Last Updated 8 Jun 2011
Article Copyright 2011 by Balu Sathish
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid