Hi,
If you add a tablestyle the datagridtextboxcolumn has a nulltext
property.
Private Sub SetupGrid()
Dim ts As New DataGridTableStyle
ts.MappingName = dsInvoicesData.Tables(0).TableName
Dim colDescription As New DataGridTextBoxColumn
With colDescription
..MappingName = "Description"
..HeaderText = "Description"
..Width = 280
..NullText = ""
End With
Dim colQty As New DataGridTextBoxColumn
With colQty
..MappingName = "Quantity"
..HeaderText = "Qty"
..Width = 50
End With
Dim cm As CurrencyManager = CType(Me.BindingContext(dvClient),
CurrencyManager)
Dim pd As System.ComponentModel.PropertyDescriptor =
cm.GetItemProperties()("Each")
Dim colEach As New DataGridTextBoxColumn(pd, "C")
With colEach
..MappingName = "Each"
..HeaderText = "Each"
..Width = 50
End With
Dim colPrice As New DataGridTextBoxColumn(pd, "C")
With colPrice
..MappingName = "Price"
..HeaderText = "Price"
..Width = 50
End With
ts.GridColumnStyles.Add(colDescription)
ts.GridColumnStyles.Add(colQty)
ts.GridColumnStyles.Add(colEach)
ts.GridColumnStyles.Add(colPrice)
dgInvoiceData.TableStyles.Add(ts)
ts = Nothing
colPrice = Nothing
colEach = Nothing
colQty = Nothing
colDescription = Nothing
End Sub
Ken
--------------------------------------
"John Suru" <js***@neo.rr.com> wrote in message
news:L_*****************@fe3.columbus.rr.com...
How do I force the vb.net datagrid to display a blank cell instead of
"NULL" when a field value in the database is null?
Thanks,
John Suru
