store a null in varbinary

[Guest]

hey all,
could someone please show me how to store a null value in my database
record's varbinary field using a paramerterized query?

The following doesn't work:

SqlParameter prm = new SqlParameter("@BLOBData",
SqlDbType.VarBinary, bytBLOBData.Length, ParameterDirection.Input, false,
0, 0, null, DataRowVersion.Current,
bytBLOBData);
prm.Value = DBNull.Value;
cmd.Parameters.Add(prm);

thanks,
rodchar

 

[Mark Rae]

The following doesn't work:

Come on, matey - this isn't your first post...

More info, please - e.g. error message(s) etc...

 

[Guest]

please click following link for details:

http://www25.brinkster.com/rodchar/medtest.htm