)
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 retrieve the text from a cell in WinForms GridControl?

Platform: WinForms |
Control: GridControl |
Published Date: April 30, 2011 |
Last Revised Date: December 18, 2019
Tags: editing, reading

Retrieve the text

You can retrieve the text from a cell by using the Text property, CellValue property or FormattedText property of the cell’s style object.

Using GridModel

C#

int rowIndex = 2, colIndex = 3;
// using Text property
string cellText = gridControl1[rowIndex, colIndex].Text;
// using CellValue property
object cellTextValue = gridControl1[rowIndex, colIndex].CellValue;
// using FormattedText property
string formattedText= gridControl1[rowIndex, colIndex].FormattedText;

VB

Dim rowIndex As Integer = 2, colIndex As Integer = 3
' using Text property
Dim cellText As String = gridControl1(rowIndex, colIndex).Text
' using CellValue property
Dim cellTextValue As Object = gridControl1(rowIndex, colIndex).CellValue
' using FormattedText property
Dim formattedText As String= gridControl1(rowIndex, colIndex).FormattedText

Using QueryCellInfo event

C#

//Hook the Events in Form_Load
gridControl1.QueryCellInfo += gridControl1_QueryCellInfo;
void gridControl1_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)
{
    // check for particular cell
    if (e.RowIndex == 2 && e.ColIndex == 3)
    {
        string text = e.Style.Text;
        object cellValue = e.Style.CellValue;
        string formattedText = e.Style.FormattedText;
    }
}

VB

'Hook the Events in Form_Load
gridControl1.QueryCellInfo += gridControl1_QueryCellInfo
Private Sub gridControl1_QueryCellInfo(ByVal sender As Object, ByVal e As GridQueryCellInfoEventArgs)
   ' check for particular cell
   If e.RowIndex = 2 AndAlso e.ColIndex = 3 Then
       Dim text As String = e.Style.Text
       Dim cellValue As Object = e.Style.CellValue
       Dim formattedText As String = e.Style.FormattedText
   End If
End Sub

 

Note:

Depending upon exactly what object is stored in the CellValue property, you have to perform the additional work to retrieve a ’usable value’ from the style. Refer to the specific examples regarding the ColorEdit control and the NumericUpDown controls in the Controls section of this FAQ.

 

Samples:

C#: RetriveTextSample

VB:

RetriveTextSample

 

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