)
We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to extract the entire data for particular column in WinForms GridControl?

Platform: WinForms |
Control: GridControl |
Published Date: May 4, 2016 |
Last Revised Date: December 16, 2019

Extract entire data

The values of a specific column can be obtained by using DrawCellDisplayText event. This event occurs for every cell before the grid draws the display text for the specified cell. But you have a limitation here, this event gets triggered only when the cell is in view state. In this sample we have added the second columns value to a list box control using button click.

 

The rows which are not came into the view will not be added into the list. So, iteration would be the only way to get the values other cells which are not viewable.

 

C#

void grid_DrawCellDisplayText(object sender, GridDrawCellDisplayTextEventArgs e)
{
    if (e.ColIndex == 2 && e.RowIndex > 0 && !list1.Contains(e.DisplayText))
    {
        list1.Add(e.DisplayText);
    }
}

 

VB

Private Sub grid_DrawCellDisplayText(ByVal sender As Object, ByVal e As GridDrawCellDisplayTextEventArgs)
 If e.ColIndex = 2 AndAlso e.RowIndex > 0 AndAlso (Not list1.Contains(e.DisplayText))        Then
  list1.Add(e.DisplayText)
 End If
End Sub

 

Extract entire data for particular column

 

Samples:

C#: ExtractData_C#

VB: ExtractData_VB

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon