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

Hi Doris,

Thanks. I'll keep playing with this today. I think I tried something similar 
yesterday and couldn't get it to work, but chances are I was just having an 
attack of brain gas :)

Ron
 


> 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
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>