I want to update the date and time from two separate pickers to my table.
My 2 DTPers are bound to a dataset.
One is in the Short Format, the other is Time.
I have several other bound controls, and I just do a .Update to update my table. I tried just updating the row:
but it throws an exception when I do my save.Code:Me.DsTradeShow1.Tables("Tradeshow_Details").Rows(0).Item("Show_Date") = CDate(Me.DateTimePicker15.Text & " " & Me.DateTimePicker16.Text)
Any help would be appreciated!




Reply With Quote