Help with DataAdapter Update

  • Thread starter Thread starter AMDRIT
  • Start date Start date
A

AMDRIT

Hello everyone,

I have a data adapter and would really like to be able to change the value
of a column on update. I am using

New System.Data.SqlClient.SqlParameter("@DateModified",
System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input,
False, CType(0, Byte), CType(0, Byte), "DateModified",
System.Data.DataRowVersion.Original, Now)

and when I add a watch to it, it shows a date value. However, when I trace
the update statement on SQL server, it comes out as Null. The value of the
datacolumn is null, I would like to change it to Now during the update.

Anyone have any ideas as to how to overcome this?


Thanks
 
I figured it out

New System.Data.SqlClient.SqlParameter("@DateModified", Now)

is all I needed.
 
Back
Top