VB.Net SqlDbType.DateTime Question

[alex_read]

I have a SQL Server stored procedure which accepts a datetime parameter to filter it's resulting data by. This has the following statement declared at the start:

SET DATEFORMAT dmy

Through the SQL Query Analyzer, I can run this stored procedure, using either of the following, and receive results:

SET @FromDate = '30-12-2004 00:01:01:001'
SET @FromDate = '30/12/2004'

Placing exactly the same strings in the following code within vb.net, produces a "String was not recognized as a valid DateTime." exception message! Can someone please explain how I can pass a date value into the SQLClient.SQLCommand object successfully???

cmdSQL = New SqlClient.SqlCommand
 
cmdSQL.Parameters.Add("@FromDate", SqlDbType.DateTime).Value= ?????
cmdSQL.Parameters.Item(0).Direction = ParameterDirection.Input

Thanks!!