Hi RML,
The following code worked fine for me. Is it possible that your column is
not really a datetime column? Otherwise, I don't understand why you should
not be seeing the time. Are you displaying it in shortdatetime format?
strsqlselect = "select * from tblministryjoin order by todate"
Dim dam As OleDbDataAdapter
dam = New OleDbDataAdapter(strsqlselect, oconn)
Dim odsm As New DataSet("tblministryjoin")
dam.Fill(odsm, "tblministryjoin")
Dim commandbuilder_odsm As OleDbCommandBuilder = New
OleDbCommandBuilder(dam)
Dim irowm As DataRow
For Each irowm In odsm.Tables(0).Rows
irowm("fromdate") = Now
MessageBox.Show(Now)
MessageBox.Show(irowm("fromdate"))
Exit For
Next
Try
dam.Update(odsm, "tblministryjoin")
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
HTH,
Bernie Yaeger
"RML" <RM*@discussions.microsoft.com> wrote in message
news:3F**********************************@microsof t.com...
Hi everyone,
I am using VB.NET 2003 and an OleDBDataAdapter to update an Access table's
DateTime field. The field's format is set to "General Date" (ie:
11/24/2004
8:00:00 AM). The problem is the field ends up with only a date, with no
time
component.
In my project...
I added an OleDBDataAdapter using the wizzard to my form. I generated the
DataSet and added the desired table. I verified the field type in the
DataSet is "dateTime".
My code does this...
Me.dsTaskPro(0).CompletedOn = Now
Me.daTaskProcess.Update(Me.dsTaskPro)
The field ends up with today's date "11/24/2004", with no time component.
If I edit the field (using Access) with a date & time, say 11/24/2004
8:00:00 AM and then run my code I get a "Concurrency Violation" exception.
Amyone have any ideas?
Thanks RML