|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Anyone looking for a way to modernize legacy data or easily migrate to a more cost-effective database without sacrificing functionality will benefit from this seminar. View the Intro to Advantage Database Server now! |
|
#1
|
|||
|
|||
|
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
__________________
George - www.ipdg3.com Helping Developers and Programmers Find Resources Forums - Contests - Tutorials - Source Code ORB - Wireless Site - Online Gear |
|
#2
|
|||
|
|||
|
I believe this will work.
PHP Code:
You can assign it to a button like this. PHP Code:
Now all I need to do is get these dates to stop displaying like this in the textbox 1/1/2003 12:00:00 AM |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > ADO.NET SQL Server Bound Controls and SmallDateTime Type |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|