Articles in this section
Category / Section

How to retrieve the text from a cell in WinForms GridControl?

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

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;
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 the QueryCellInfo event

//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;
    }
}
'Hook the Events in Form_Load
AddHandler gridControl1.QueryCellInfo, AddressOf 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

 

Conclusion


I hope you enjoyed learning about how to retrieve the text from a cell in WinForms Grid Control.


You can refer to our WinForms GridControl feature tour page to know about its other groundbreaking feature representations and WinForms GridControl documentation, and how to quickly get started for configuration specifications.


For current customers, you can check out our 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 other controls.


If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-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)
Access denied
Access denied