How to copy selected rows including hidden columns from Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl

[Katherine]

How to copy selected rows including hidden columns from Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl?

[Katherine]

We would like to copy the records to the clipboard.

[SubhaSheela R]

Hi Katherine,

Thank you for using Syncfusion products.

You can copy the selected row to clip board including hidden cell by getting all the columns in the GridGrouping control using GridColumnDescriptor. After getting all the columns, you can get details of selected record by using GetValue method of Record class. Below is the code snippet:

private void CopySelectedRecords()
        {
            foreach (SelectedRecord selRec in this.gridGroupingControl1.Table.SelectedRecords)
            {
                for (int i = 0; i < this.gridGroupingControl1.TableDescriptor.Columns.Count; ++i)
                {
                    GridColumnDescriptor vcd = this.gridGroupingControl1.TableDescriptor.Columns[i];
                    if (i != 0)
                        s += '\t';
                    s += selRec.Record.GetValue(vcd.Name).ToString();                }
                s += Environment.NewLine;
            }
            Clipboard.SetDataObject(new DataObject(s), true);
        }
    }

Please refer the sample available in the link below and let me know if it helps:

http://websamples.syncfusion.com//samples/ Grouping.Windows/F71413/main.htm

Regards,
Subhasheela R

[Santosh U]

Hi Subhasheela,

I have downloaded and used your code It works well. I have modified it for visiblecolumns only.

Now my columns are of type Combo Box so I get the value instead of display text (which I am fine with).

I want to paste this same copied rows in the same grid below (where AddNewRecord is there, How can we achieve this.

Please help,
Thanks,
Santosh U