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

[quoted text, click to view]

¤ 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
~~~~

I addition to Paul`s response

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



"Tony M" <TonyMast_NOSPAM@msn.com> schreef in bericht
news:%23Os0i7yzHHA.5052@TK2MSFTNGP04.phx.gbl...
[quoted text, click to view]