问题描述
大家好，
我遇到了这个奇怪的问题:
我的数据库中有一个表，我为此添加了行.
我添加2行完美.每次添加后，我都使用DataAdapter.Fill()填充DataTable.
比起第三次我得到这个奇怪的执行:The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
问题是，我的数据库中没有任何varchar数据类型！我的猜测是，因为我使用的是他"-我在区域设置"中设置的希伯来语语言，而不是将MSSQL设置为en-us.
没有人知道为什么会发生这种情况吗?
thx！
hi all,
i''ve encountered this weird problem:
i have a table in my database for which i add rows.
i add 2 rows perfect. after each addition i fill a DataTable using DataAdapter.Fill().
than, at the 3rd time i get this weird execption:The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
the thing is, i don''t have any varchar datatype in any of my database!!!
my guess is that, because i am using "he" - which is hebrew language set on my "Regional Settings", as opposed to the MSSQL set to en-us.
does anyone has a clue why this happens??
thx!
推荐答案
这篇关于将varchar数据类型转换为smalldatetime数据类型会导致超出范围的值.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！