UltraGrid displaying Null and Empty values

Hi All,

I have some columns that can be filled with a Null value or an Empty value.

All I want is to let the user choose what the value of the cell:

– if the cell is cleared then the value should be empty (shown as empty/blank)

– if the cell is filled with “NULL” text then the value should be DbNull.value (shown with text “NULL”)

I have tried to set this with a EditorDataFilter but it doesn’t seems to work and I don’t know if it is the right way to procede.

Is there any proper way to achieve this ?

Hello Bruno,

Thank you for contacting Infragistics!

The behavior of an empty/blank cell being displayed when the value is cleared out is the default behavior. To have the null text be “Null” you can set the “UltraGrid.DisplayLayout.Override.NullText” to “NULL”. As for setting null when the user enters “NULL” I would recommend handling the AfterExitEditMode or BeforeExitEditMode event of the grid and if the text is “NULL” set the value to null.

Hi Mike,

Thank you very much, this is indeed working [emoticon:6d505171faa4497c85c5ca27290c555d]
For anyone interested, here is the implementation :

Public Sub New()
	myUltraGrid.DisplayLayout.Override.NullText = "NULL"
End Sub

Private Sub myUltraGrid_AfterExitEditMode(sender As Object, aArgs As EventArgs) Handles myUltraGrid.AfterExitEditMode
	'get new value of the cell
	Dim newCellValue As Object = myUltraGrid.ActiveCell.Value
	
	'set DBNULL if value is "NULL"
	If newCellValue.GetType() = GetType(String) then
		Dim strCellValue as string = CStr(newCellValue)
		If strCellValue = "NULL" then
			myUltraGrid.ActiveCell.Value = DBNull.Value
		End If
	End If
End Sub