ASP .net - webforms

I changing things from sql string concatenation to parameters, for sql 
injection reasons.

I keep getting a data type mismatch error.

I know the field / column is date/time and it worked with the string 
concatenation .

OleCmd.Parameters.AddWithValue("LastChangeTime", Now)



Can someone tell me how to pass a date (Now)?



Thanks

On Wed, 25 Jul 2007 22:44:17 -0400, "Tony M"  wrote:

 ASP .net - webforms
 
 I changing things from sql string concatenation to parameters, for sql 
 injection reasons.
 
 I keep getting a data type mismatch error.
 
 I know the field / column is date/time and it worked with the string 
 concatenation .
 
 OleCmd.Parameters.AddWithValue("LastChangeTime", Now)
 
 
 
 Can someone tell me how to pass a date (Now)?

You probably need to specify the data type of the parameter:

System.Data.OleDb.OleDbType.Date


Paul
~~~~
Microsoft MVP (Visual Basic)

I addition to Paul`s response

it is also possible to pass the date as a string ( i prefer ISO 8601 )



"Tony M"  schreef in bericht 
news:%23Os0i7yzHHA.5052@TK2MSFTNGP04.phx.gbl...

> ASP .net - webforms
>
> I changing things from sql string concatenation to parameters, for sql 
> injection reasons.
>
> I keep getting a data type mismatch error.
>
> I know the field / column is date/time and it worked with the string 
> concatenation .
>
> OleCmd.Parameters.AddWithValue("LastChangeTime", Now)
>
>
>
> Can someone tell me how to pass a date (Now)?
>
>
>
> Thanks
>
>