#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Location
    USA
    Posts
    313
    Rep Power
    19

    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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Location
    USA
    Posts
    313
    Rep Power
    19
    I believe this will work.
    PHP Code:
    Me.dsMediaInfo.Tables("MediaInfo" ).Rows(0).Item(4) = System.DBNull.Value 
    You can assign it to a button like this.
    PHP Code:
        Private Sub btnClearDate_Click(ByVal sender As _
        System
    .ObjectByVal e As System.EventArgsHandles _
        btnClearDate
    .Click

            MessageBox
    .Show(Me.dsMediaInfo.Tables("MediaInfo" ).Rows(0).Item(4))

            
    Me.dsMediaInfo.Tables("MediaInfo" ).Rows(0).Item(4) = System.DBNull.Value

        End Sub 
    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

IMN logo majestic logo threadwatch logo seochat tools logo