Convert Nulls to Blank in dataset/datagrid 1

[Trancedified]

I have this code:

strSQL = "SELECT Toc.Name AS [Document Name], ISNULL([ID Number], ''), ISNULL([Last Name], '') FROM TD4"

Supposedly that changes the (nulls) in my datagrid to blanks but instead it's showing 1/1/1900.

Any ideas on how to change it to a blank?

Chris

 

[PankajBanga]

You DataGridColumnStyle.NullText[/] Property, which sets the text that is displayed when the column contains a null reference (Nothing in Visual Basic).

Private Sub SetNullText()
Dim myGridColumn As DataGridColumnStyle
myGridColumn = dataGrid1.TableStyles(0).GridColumnStyles(0)
'This will covert NULL to BLANK.
myGridColumn.NullText = ""
End Sub 'SetNullText



Email: pankajmsm@yahoo.com

 

[PankajBanga]

Ignore the typo's

Use DataGridColumnStyle.NullText Property, which...

Email: pankajmsm@yahoo.com