I am trying out using Net with MS-SQL and using the standard SQL connection. I am still not sure how DATETIME parameters are best handled when passing data to and from MS-SQL.

From my intial test it seems that as long as I pass DateTIME date as parameter values MS-SQL will correctly interprete these without any special handling routines even if the Client and the Server have different regional settings.

Can anybody guide on the best way to handle this.