I am using an Access Database and populating a Datagrid. I have 2 time fields in the database. They use the date/time format in the database. When displayed in the grid, they show up with 12/30/1899 preceeding the time. Then I changed the database to use short times. The same thing occurred. Is there a problem with a datagrid where it always shows this date in the time field? Here is the code:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        If Not IsPostBack Then
            OleDbConnection1.Open()
            Dim reader As System.Data.OleDb.OleDbDataReader
            reader = OleDbCommand1.ExecuteReader
            DataGrid1.DataSource = reader
            DataGrid1.DataBind()
            reader.Close()
            OleDbConnection1.Close()



        End If


    End Sub

Thanks for any help with this.

I dont think its a problem.

I think that the default date is probably stored the same way in the database as it previously was, its just the format that the field is displayed that has changed.

I could be wrong about that, but it will be quite easy to format the column on the datagrid to display the date in a certain format regardless of how the date is stored, as long as its a valid date.

hth