tags:

views:

22

answers:

0

i work on C# window vs05......i save image on sql server by oledb command ...in insertion i insert null value on image field .........i works well problem occur when i try to update image ........My update query is.....

using (OleDbCommand Update = new OleDbCommand( "UPDATE [BoardDetail] SET BoardImage= '(?)' WHERE BoardID='" + oItem.BoardID + "' AND BoardSerialNo='" + oItem.BoardSerialNo + "' ", connection))
{ OleDbParameter imageParameter = Update.Parameters.Add("@image", OleDbType.Binary); imageParameter.Value = content; imageParameter.Size = content.Length; Update.ExecuteNonQuery(); }

it works well but value on image column is null .......