
February 18th, 2003, 01:54 PM
|
|
Contributing User
|
|
Join Date: Nov 2001
Location: USA
|
|
|
ADO.NET SQL Server Bound Controls and SmallDateTime Type
Ok I am creating a program in VB.NET that has a textbox that is bound with ado.net and BindingContext etc. The field it is bound to is a SmallDateTime. Here is the problem say I put a date in it and save it all is good. Now say I go back and take the date out of the field it keeps coming back. I am pretty sure it has something to do with the BindingContext and dataset but am not sure how to set it to NULL.
Me.BindingContext(Me.dsMediaInfo, "MediaInfo")
This is not right but this is what I want.
TextBox5.Text = NULL
I need to change the current bound record SmallDateTime to NULL
|