Question on parameter.Add for an SQL Insert

I'm trying to update my database table from my dataset.

In the following statement, the ? represents the "size as integer" of the SqlDbType of DateTime and I can't fiqure out what to put there.

command.Parameters.Add("@ItemDate", SqlDbType.DateTime, ?,"ItemDate")

In the following statement I understand the "50" since it is the size of the field, but I don't understand what to do with the DateTime.

command.Parameters.Add("@ItemText", SqlDbType.NVarChar, 50,"ItemText")

Thank you for your help

[788 byte] By [xprs] at [2008-3-1]

# 1

This chart might help:

Buck Woody

BuckWoody at 2007-10-7 >

SQL Server Hot Topic