Single Cell Edit?

[Pramod Viswanath]

In essential data grid, is there some kind of property to set so that all the cells in the grid except one can be made read only?

I am looking for a feature where in, I should just be passing a row number and column number for a cell which needs to be editable and the rest non-editable.

Thanks
Pramod.

[haneefm]

Hi Pramod,

You can do this by handling the QueryCellInfo event of the grid and set the Style.ReadOnly property to true. Below is a code snippet.

this.gridDataBoundGrid1.Model.QueryCellInfo +=new GridQueryCellInfoEventHandler(Model_QueryCellInfo);

private void Model_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)
{
if( e.RowIndex == 2 && e.ColIndex == 2 )
e.Style.ReadOnly = false;
else
e.Style.ReadOnly = true;
}

Best regards,
Haneef

[Pramod Viswanath]

Haneef.

Thanks a lot for this snippet. Is this possible with just the DataGrid provided by SyncFusion? Not the GridDataBoundGrid.

Thanks
Pramod.

>Hi Pramod,

You can do this by handling the QueryCellInfo event of the grid and set the Style.ReadOnly property to true. Below is a code snippet.

this.gridDataBoundGrid1.Model.QueryCellInfo +=new GridQueryCellInfoEventHandler(Model_QueryCellInfo);

private void Model_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)
{
if( e.RowIndex == 2 && e.ColIndex == 2 )
e.Style.ReadOnly = false;
else
e.Style.ReadOnly = true;
}

Best regards,
Haneef

[haneefm]

Hi Pramod,

For GridGroupingGrid:

Please try this code.

this.gridGroupingControl1.QueryCellStyleInfo +=new GridTableCellStyleInfoEventHandler(gridGroupingControl1_QueryCellStyleInfo);

private void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e)
{
if( e.TableCellIdentity.RowIndex == 4
&& e.TableCellIdentity.ColIndex == 4)
{
e.Style.ReadOnly = false;
e.Style.BackColor = Color.Red;
}
else
e.Style.ReadOnly = true;
}

For GridControl :

You can try this code snippet to resolve this in a GridControl

this.gridControl1.QueryCellInfo +=new GridQueryCellInfoEventHandler(gridControl1_QueryCellInfo);

private void gridControl1_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)
{
if( e.RowIndex == 4
&& e.ColIndex == 4)
{
e.Style.ReadOnly = false;
}
else
e.Style.ReadOnly = true;
}

Best regards,
Haneef