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).FormattedTextUsing 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:
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!