How do I make the cells as ReadOnly in GridDataBoundGrid?

2 mins read

GridDataBoundGrid allows you to make the cell read-only by setting the ReadOnly property in the Grid model, or using the QueryCellInfo event.

Using GridModel

//Apply Readonly to column 1
this.gridDataBoundGrid1.Binder.InternalColumns[1].StyleInfo.ReadOnly = true;

'Apply Readonly to column 1
Me.gridDataBoundGrid1.Binder.InternalColumns(1).StyleInfo.ReadOnly = True

Using QueryCellInfo

void Model_QueryCellInfo(object sender, Syncfusion.Windows.Forms.Grid.GridQueryCellInfoEventArgs e)
{
//Apply Readonly to cell(3,3)
if (e.RowIndex == 3 && e.ColIndex == 3)
{
e.Style.BackColor = Color.Yellow;
e.Style.ReadOnly = true;
}
// Apply ReadOnly to Row 4
if (e.RowIndex == 4)
{
e.Style.BackColor = Color.Blue;
e.Style.ReadOnly = true;
}
// Apply ReadOnly to Column 4
if (e.ColIndex == 4)
{
e.Style.BackColor = Color.Aqua;
e.Style.ReadOnly = true;
}
// Apply ReadOnly to Range of cells
if ((e.RowIndex == 1 || e.RowIndex == 2) && (e.ColIndex == 1 || e.ColIndex == 2))
{
e.Style.BackColor = Color.Red;
e.Style.ReadOnly = true;
}
}

Private Sub Model_QueryCellInfo(ByVal sender As Object, ByVal e As Syncfusion.Windows.Forms.Grid.GridQueryCellInfoEventArgs)
'Apply Readonly to cell(3,3)
If e.RowIndex = 3 AndAlso e.ColIndex = 3 Then
e.Style.BackColor = Color.Yellow
e.Style.ReadOnly = True
End If
' Apply ReadOnly to Row 4
If e.RowIndex = 4 Then
e.Style.BackColor = Color.Blue
e.Style.ReadOnly = True
End If
' Apply ReadOnly to Column 4
If e.ColIndex = 4 Then
e.Style.BackColor = Color.Aqua
e.Style.ReadOnly = True
End If
'Apply ReadOnly to Range of cells
If (e.RowIndex = 1 OrElse e.RowIndex = 2) AndAlso (e.ColIndex = 1 OrElse e.ColIndex = 2) Then
e.Style.BackColor = Color.Red
e.Style.ReadOnly = True
End If

After applying the properties, the cell is displayed as follows,

Query Cell Style Info