ms访问不允许datetimepicker中的null [英] ms access not allow null in datetimepicker

问题描述

我使用三个带有可选的datetimepicker工具.这意味着无论您是否使用，都不会在用户心中.从数据库检索数据时显示错误"DBNULL not not convert to string".我可以将vb.net与ms访问一起使用

I use Three datetimepicker tool with optional. It means either use or not at user mind.At the time of data retrieve from database to show error "DBNULL not convert to string" . I could use vb.net with ms access

推荐答案

您是否已在数据库字段描述中设置允许空值"?

顺便说一句:永远不要将日期存储为字符串:改用DateTime数据类型.这样，您就可以对它们进行比较和/或数学运算，并且不必担心浏览器或操作系统将处理转换时世界范围内使用的各种日期格式.

Have you set "Allow nulls" in the database field description?

BTW: Don''t ever store dates as strings: use the DateTime datatype instead. That way you can do comparisons and / or math on them, and you do not have to worry about the various date formats used worldwide as the browser or OS will handle the conversion.

这篇关于ms访问不允许datetimepicker中的null的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！