Author: gamaz | Posted on: 3/3/2009 7:34:20 AM | Views : 262

Hi,

I have a date field row in a table that needs to be updated. The sql server datatype for this field is datetime.

 I am updating the row using stored procedure with parameters

However, when the procedure is run there is error and does not update the field.

I am using the following parameter from asp.net web form page:

  cmd_r.Parameters.Add("@poduedate", Data.SqlDbType.DateTime)
  cmd_r.Parameters("@poduedate").Value = Convert.ToDateTime(txtDueDate.Text)

I want to know if the above two lines of code are correct to pass date parameter in a stored procedure. I appreciate any help for resolution of this issue.
...

Go to the complete details ...