VB.NET2003中DATAGRID里 零 值的显示问题

[九斤半]

Dim TS As New DataGridTableStyle
Dim TC As New DataGridTextBoxColumn

TC = New DataGridTextBoxColumn
TC.MappingName = "QTY"
TC.HeaderText = "数量"
TC.Width = 80
TC.NullText = ""
TC.Format = "0.00##;-0.00##"
TC.Alignment = HorizontalAlignment.Right
TS.GridColumnStyles.Add(TC)

我想让QTY=0的值不显示,即跟NullText=""那样的,该如何设置啊?

在线急等.

[catlee1027]

老板,来十斤椅子

[zicxc]

他只有 九斤半 ，要不饶你5毛钱

[zmaini1420]

不会，来帮你顶下，随便来看看学习下

[zicxc]

有没试过

TC.Format = "0.00;-0.00"

[九斤半]

zicxc(冒牌邹建 V0.3) ( ) 信誉：100 Blog

有没试过

TC.Format = "0.00;-0.00"
------------------------
那它就显示0.00了 ##是有数则显示,为零则不显示.

Format可能不行.

[W_W_Q]

这样可以重写DataGridTextBoxColumn，很简单
Public Class myDataGridTextBoxColumn

Inherits DataGridTextBoxColumn '继承




Private Function GetText(ByVal Value As Object) As String

'为进行重绘读出textbox中的内容，这个函数是增加容错能力的，与实现机制无关

If TypeOf (Value) Is System.DBNull Then

Return NullText

ElseIf Value Is Nothing Then

Return ""

Else

Return Value.ToString

End If

End Function



Protected Overloads Overrides Sub Paint( _
ByVal g As System.Drawing.Graphics, _
ByVal bounds As System.Drawing.Rectangle, _
ByVal source As System.Windows.Forms.CurrencyManager, _
ByVal rowNum As Integer, _
ByVal backBrush As System.Drawing.Brush, _
ByVal foreBrush As System.Drawing.Brush, _
ByVal alignToRight As Boolean)



Dim text As String

'按默认模式重绘

text = GetText(GetColumnValueAtRow(source, rowNum)) '这句就是上文提及的取数据

If CDec(text) = 0 Then '如果是0
MyBase.PaintText(g, bounds, "", backBrush, foreBrush, alignToRight)
Else
MyBase.PaintText(g, bounds, CDec(text).ToString(MyBase.Format), backBrush, foreBrush, alignToRight)
End If



End Sub

End Class

[股神]

顶

[leq_82]

顶

[netcup]

帮忙顶

[hzybc]

TC.MappingName = iif(QTY=0,"","QTY")

[九斤半]

TC.MappingName = IIf(QTY=0,"","QTY") ' 不行
TC.MappingName = IIf("QTY"=0,"","QTY") ' 不行
TC.MappingName = IIf("QTY=0","","QTY") ' 不行

[九斤半]

W_W_Q(韦一笑) 的重绘应该可以，不过不想重绘，因为牵涉到其它方面的问题。

想到另一个办法：先在数据库(MS SQL)中处理一下
SELECT ……,CASE WHEN QTY=0 THEN NULL ELSE QTY END AS QTY FROM ……
然后再 TC.NullText = ""

虽然这样可以，不过也没有这样做，希望得到其它的更好的答案。

[ou108]

暈
回答得這麼多
來晚了，用iif是正點