[dba-SQLServer] formatting smalldatetime textbox (somewhat OT)

The easiest solution would be to make sure the stored procedure includes a
reference to both the original date field and the converted date.  

Bind the textbox to the converted date.  

In your Update stored procedure, put the update parameter on the original
date field and not the converted one.

In your code just before you call the data adapter update, add an Update
parameter to pass the value of the textbox to the associated Update
parameter.

Doris Manning
mikedorism at verizon.net