如果你用的是TrueDBGrid的话, 则将该列的ConvertEmptyCell属性设成1(Write as Null Value)即可, 而其默认值是0(Write As is)。DBGrid功能很弱,如果条件许可,改用TrueDBGrid吧。
对于DBGrid,假设DBGrid控件名是DBGrid1,数字型列名是Salary, 则处理方法如下。Private Sub DBGrid1_BeforeUpdate(Cancel As Integer) If DBGrid1.Columns("Salary").Value = "" Then DBGrid1.Columns("Salary").Value = Null End If End Sub
则将该列的ConvertEmptyCell属性设成1(Write as Null Value)即可,
而其默认值是0(Write As is)。DBGrid功能很弱,如果条件许可,改用TrueDBGrid吧。
则处理方法如下。Private Sub DBGrid1_BeforeUpdate(Cancel As Integer)
If DBGrid1.Columns("Salary").Value = "" Then
DBGrid1.Columns("Salary").Value = Null
End If
End Sub
的话,联系起来就很方便。