为日期数据类型分配空值 [英] Assign null value to date datatype

问题描述

亲爱的编码员，

我在将日期数据类型值分配为null时遇到麻烦.如果我分配像

Dear Coders,

I am having trouble assigning a date datatype value to null. If i assign like

Dim MyDate as Date

MyDate = DbNull.value

它显示错误，如无法转换值.请帮忙.

Its showing error like cannot convert the value. Please Help.

推荐答案

您不能将DBNull.Value特别分配给任何东西-它是在.NET和SQL之间传递的表示空值的值数据库表中的值，而不是通常在应用程序中可以使用的值.请尝试使用Nothing. (但是那可能不会做你想要的事情:笑:)

You can''t assign DBNull.Value to anything in particular - it is a value that is passed between .NET and SQL to indicate a null value in a database table, not a value you can generally use in your application. Try Nothing instead. (But that probably won''t do what you want either :laugh:)

这是你要找的吗.-

Is this you looking for.. - Assigning null value to datetime object[^]

armarzook写道:

armarzook wrote:

MyDate = DbNull.value

MyDate = DbNull.value

如果您不使用ADO.Net，则DbNull不会代表任何内容.

here DbNull does not represent anything if you are not using ADO.Net..

这篇关于为日期数据类型分配空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！