[2005] DateTime Bindings DateTimePickers

[jmcilhinney]

First up, if you're manually moving the data from the controls to the DataTable then there's no binding going on. The whole point of binding is so you do NOT have to write your own code to move the data.

As for the code you do have, don't ever use strings to manipulate dates if it can be avoided. Your DataTimePickers already contain DateTime values and you want a DateTime value so there is no reason at all for using strings anywhere in the equation.

Also, please use descriptive names for all variables. "DateTimePicker15" and "DateTimePicker16" mean nothing to anyone.

Me.DsTradeShow1.Tables("Tradeshow_Details").Rows(0).Item("Show_Date") = Me.datePicker.Value.Date.Add(Me.timePicker.Value.TimeOfDay)

That code gets the DateTime from the date picker, zeroes the time and then adds the TimeSpan from the time picker.