Articles in this section
Category / Section

How to paste the data in the current cell when the ListBoxSelectionMode is enabled in WinForms GridControl?

2 mins read

Paste the data

In the WinForms GridControl, pasting the data in the current cell when the ListBoxSelectionMode is enabled is achieved by handling the ClipboardCanPaste event. By using this event, you can get the Clipboard text by accessing the GetData()of the GetDataObject() method. Then the data can be pasted in the current cell by using the PasteTextFromBuffer method.

C#

this.gridControl1.ListBoxSelectionMode = SelectionMode.One;
this.gridControl1.ClipboardCanPaste += new GridCutPasteEventHandler(gridControl1_ClipboardCanPaste);
void gridControl1_ClipboardCanPaste(object sender, GridCutPasteEventArgs e)
{
    //Checks whether the range is a Row.
    if (e.RangeList.ActiveRange.RangeType == GridRangeInfoType.Rows)
    {
        GridCurrentCell currentCell = this.gridControl1.CurrentCell;
        if (currentCell != null)
        {
            //Gets the Clipboard text.
            string clipboardText = Clipboard.GetDataObject().GetData(DataFormats.UnicodeText) as string;
            //Sets the ClipBoard text to the current cell.
            this.gridControl1.Model.TextDataExchange.PasteTextFromBuffer(clipboardText, currentCell.RangeInfo, e.ClipboardFlags);
            e.Result = false;
            e.Handled = true;
        }
    }
}

VB

Me.gridControl1.ListBoxSelectionMode = SelectionMode.One
AddHandler gridControl1.ClipboardCanPaste, AddressOf gridControl1_ClipboardCanPaste
'Handles the ClipboardCanPaste event.
Private Sub gridControl1_ClipboardCanPaste(ByVal sender As Object, ByVal e As GridCutPasteEventArgs)
    'Checks whether the range is a Row.
     If e.RangeList.ActiveRange.RangeType = GridRangeInfoType.Rows Then
           Dim currentCell As GridCurrentCell = Me.gridControl1.CurrentCell
              If currentCell IsNot Nothing Then
                  'Gets the Clipboard text.
                   Dim clipboardText As String = TryCast(Clipboard.GetDataObject().GetData(DataFormats.UnicodeText), String)
                 'Sets the ClipBoard text to the current cell.
           Me.gridControl1.Model.TextDataExchange.PasteTextFromBuffer(clipboardText, currentCell.RangeInfo, e.ClipboardFlags)
                 e.Result = False
                 e.Handled = True
             End If
       End If
End Sub

 

The following screenshot displays the data pasted when the LisBoxSelectionMode is enabled.

Data pasted when the listbox selection mode is enabled in WinForms GridControl

 

Samples:

C#: PastedData

VB: PastedData

 

Reference link: https://help.syncfusion.com/windowsforms/grid-control/copy-and-paste

 

Conclusion

I hope you enjoyed learning about how to paste the data in the current cell when the ListBoxSelectionMode is enabled in WinForms GridControl.

You can refer to our WinForms GridControl’s feature tour page to know about its other groundbreaking feature representations. You can also explore our WinForms GridControl documentation to understand how to present and manipulate data.

For current customers, you can check out our WinForms components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our WinForms GridControl and other WinForms components.

If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forumsDirect-Trac, or feedback portal. We are always happy to assist you!

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied