Update Image not working

[rayanmoussa]

Hi all, i am having problems updateing images to db, the insert statement works fine. this is my code

 command = new SqlCommand("UPDATE ITEMS SET IMG_NAME='@img_name', IMG_DATA='@img_data', IMG_CONTENTTYPE='@img_contenttype', NAME='@name', CATEGORY='@cat', PRICE='@price', DERSCIPTION='@desc', QUANTITY='@quant' WHERE IMG_PK='@imgId'", connection);
 
 
   SqlParameter param0 = new SqlParameter("@img_name", SqlDbType.VarChar, 50);
                    param0.Value = imgName;
                    command.Parameters.Add(param0);
 
                    SqlParameter param1 = new SqlParameter("@img_data", SqlDbType.Image);
                    param1.Value = imgBinaryData;
                    command.Parameters.Add(param1);
 
                    SqlParameter param2 = new SqlParameter("@img_contenttype", SqlDbType.VarChar, 50);
                    param2.Value = imgContentType;
                    command.Parameters.Add(param2);
 
                    SqlParameter param3 = new SqlParameter("@name", SqlDbType.VarChar, 50);
                    param3.Value = szName;
                    command.Parameters.Add(param3);
 
                    SqlParameter param4 = new SqlParameter("@cat", SqlDbType.Int);
                    param4.Value = iCat;
                    command.Parameters.Add(param4);
 
                    SqlParameter param5 = new SqlParameter("@price", SqlDbType.Decimal);
                    param5.Value = dPrice;
                    command.Parameters.Add(param5);
 
                    SqlParameter param6 = new SqlParameter("@desc", SqlDbType.VarChar, 300);
                    param6.Value = szDesc;
                    command.Parameters.Add(param6);
 
                    SqlParameter param7 = new SqlParameter("@quant", SqlDbType.Int);
                    param7.Value = iQuantity;
                    command.Parameters.Add(param7);
 
 SqlParameter param13 = new SqlParameter("@imgId", SqlDbType.VarChar, 25);
                    param13.Value = szImgIdNew;
                    command.Parameters.Add(param13);
 
 
 
 
                    connection.Open();
                    numRowsAffected = command.ExecuteNonQuery();
                    connection.Close();

* numRowsAffected always returns 0 i checked there are no null values, thanks for your help

[ck9663]

Display the entire SQLCommand in a window. Copy that command and paste it on a query analyzer and execute it.

See if it executes properly. We'll go from there....

Good Luck!!!

~~ CK