GDBG Control: show nulls and reset values.

[Administrator]

Hello.
I have I already asked you about how to show (null)s for nullable empty fields in GridGroupingControl. I need the same functionality for GridDataBoundGrid, but I cannot done it same way.
Please tell me how to implement showing nulls like in standard DataGrid control.

Either I need the functionality to reset the value in datasource to DBNull for current cell.

Thanks.

[Administrator]

To display (null), you can use the PrepareViewStyleInfo event.

private void gridDataBoundGrid1_PrepareViewStyleInfo(object sender, GridPrepareViewStyleInfoEventArgs e)
{
	if(e.Style.CellValue == null || e.Style.CellValue == DBNull.Value)
	{
		e.Style.Text = "(null)";
	}
}

To set teh current cell to DBNull, you can use code like:

GridCurrentCell cc = this.gridDataBoundGrid1.CurrentCell;
cc.EndEdit();
this.gridDataBoundGrid1[cc.RowIndex, cc.ColIndex].CellValue = DBNull.Value;

[Administrator]

And how to check that the data source allows nulls for current cell ?

[Administrator]

You can try:

int field = grid.Binder.ColIndexToField(grid.CurrentCell.ColIndex);
if(myDataTable.Columns[field].AllowDBNull)
{
     //accepts DBNull.
}