Guest User

Untitled

a guest
Nov 23rd, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. Object reference not set to an instance of an object
  2.  
  3. List<CustomImage> myDeserializedImageList =
  4. (List<CustomImage>)Newtonsoft.Json.JsonConvert.DeserializeObject(images,
  5. typeof(List<CustomImage>));
  6. foreach (CustomImage element in myDeserializedImageList)
  7. {
  8. int SERVICE_NO = (int)element.SERVICE_NO;
  9. byte[] IMAGE = element.IMAGE;
  10. string sqlStatement = "INSERT INTO IMAGES (IMAGE_ID, SERVICE_NO, IMAGE ) VALUES ( IMG_ID_SEQ.nextval ,'" + SERVICE_NO + "', " + ":BlobParameter)";
  11. OracleParameter blobParameter = new OracleParameter();
  12. blobParameter.OracleDbType = OracleDbType.Blob;
  13. blobParameter.ParameterName = "BlobParameter";
  14. blobParameter.Value = IMAGE;
  15. cmd.Parameters.Add(blobParameter);
  16. cmd.CommandText = sqlStatement;
  17. imgRowId = cmd.ExecuteNonQuery();
  18. }
Add Comment
Please, Sign In to add comment