CODEWITHSUNDEEP
c#winformsdatagridviewcopy-paste
Jake
Jake

Reputation: 1660

Copy DataGridView content to clipboard. Unselected rows are comming as a blank row when pasting.!

I have a simple data grid view and I am copying its content as below:

enter image description here

When i paste this to note pad, it appear as below:

enter image description here

How can i remove the blank line between 1 Jake and 3 Tom?

I am using this code to copy:

 private void copySelectedToolStripMenuItem_Click(object sender, EventArgs e)
    {
        if (this.dataGridView1.GetCellCount(DataGridViewElementStates.Selected) > 0)
        {
            try
            {

                Clipboard.SetDataObject(
                    this.dataGridView1.GetClipboardContent());

            }
            catch (System.Runtime.InteropServices.ExternalException)
            {
                // "The Clipboard could not be accessed. Please try again.";
            }
        }
    }

Is there is any better way to copy only selected? Please Help.

Upvotes: 2

Views: 8232

Answers (2)

AsfK
AsfK

Reputation: 3476

You can loop over all selected rows:

string clipboard = "";
foreach (DataGridViewRow dgvr in dataGridView1.SelectedRows)
{
    foreach (DataGridViewColumn dgvc in dg_autoTestStatus.Columns)
        clipboard += dataGridView1.Rows[dgvr.Index].Cells[dgvc.Index].FormattedValue.ToString() + " ";
    clipboard += "\n"
}
Clipboard.SetText(clipboard);

Upvotes: 0

Jaroslav Kadlec
Jaroslav Kadlec

Reputation: 2543

I'd solved it follows:

if (this.dataGridView1.SelectedRows.Count > 0)
{
    StringBuilder ClipboardBuillder = new StringBuilder();
    foreach (DataGridViewRow Row in dataGridView1.SelectedRows)
    {
        foreach (DataGridViewColumn Column in dataGridView1.Columns)
        {
           ClipboardBuillder.Append(Row.Cells[Column.Index].FormattedValue.ToString() + " ");
        }
        ClipboardBuillder.AppendLine();
    }

    Clipboard.SetText(ClipboardBuillder.ToString());
}

Upvotes: 3

Related Questions