I'm taking a shot in the dark with this but from what I think I understand my problem is this.

The column it should be inserting to is SQL Time(7).

Now I believe that despite being able to format the DateTimePicker to a Time, or even a custom format as hh:mm:ss, or even doing the custom format in the validation step, that it still is storing the DateTime as a DateTime object, therefore despite it not visually showing the date aspect of it, it is still associated with the value being passed. IE its still passing MM:dd:yyyy hh:mm:ss TT.

Since this doesn't meat my Time(7) data type in my column, I was running into problems on both the validation of the DateTimePicker and the Coded validation I had within my DataSet to check against each column update and row update events.

This sound right?