VB.Net, Populating Null value in SQL Date/Time field

Populating Null value in SQL Date/Time field

Author	Message
Dan Shi #1 / 3	Populating Null value in SQL Date/Time field How do you put a Null value into a field that allows it? When I try it I get "Invalid cast from Enum to DateTime." My code is below:
Fri, 26 Mar 2004 03:04:35 GMT

Joe #2 / 3	Populating Null value in SQL Date/Time field Quote: > How do you put a Null value into a field that allows it? When I try it I get > "Invalid cast from Enum to DateTime." Don't you want dbNull or dbNull.Value? vbNull is one of the possible values returned by VB Classic's VarType function, along with vbEmpty, vbString, vbInteger, etc. -- Joe Foster <mailto:jlfoster%40znet.com> On the cans? <http://www.xenu.net/> WARNING: I cannot be held responsible for the above They're coming to because my cats have apparently learned to type. take me away, ha ha!
Fri, 26 Mar 2004 08:23:14 GMT

Dan Shi #3 / 3	Populating Null value in SQL Date/Time field Thanks Joe! DBNull.Value worked. Quote: > > How do you put a Null value into a field that allows it? When I try it I get > > "Invalid cast from Enum to DateTime." > Don't you want dbNull or dbNull.Value? vbNull is one of the possible > values returned by VB Classic's VarType function, along with vbEmpty, > vbString, vbInteger, etc. > -- > Joe Foster <mailto:jlfoster%40znet.com> On the cans? <http://www.xenu.net/> Quote: > WARNING: I cannot be held responsible for the above They're coming to > because my cats have apparently learned to type. take me away, ha ha!
Fri, 26 Mar 2004 10:58:13 GMT

Page 1 of 1

[ 3 post ]