Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Object reference not set to an instance of an object
- List<CustomImage> myDeserializedImageList =
- (List<CustomImage>)Newtonsoft.Json.JsonConvert.DeserializeObject(images,
- typeof(List<CustomImage>));
- foreach (CustomImage element in myDeserializedImageList)
- {
- int SERVICE_NO = (int)element.SERVICE_NO;
- byte[] IMAGE = element.IMAGE;
- string sqlStatement = "INSERT INTO IMAGES (IMAGE_ID, SERVICE_NO, IMAGE ) VALUES ( IMG_ID_SEQ.nextval ,'" + SERVICE_NO + "', " + ":BlobParameter)";
- OracleParameter blobParameter = new OracleParameter();
- blobParameter.OracleDbType = OracleDbType.Blob;
- blobParameter.ParameterName = "BlobParameter";
- blobParameter.Value = IMAGE;
- cmd.Parameters.Add(blobParameter);
- cmd.CommandText = sqlStatement;
- imgRowId = cmd.ExecuteNonQuery();
- }
Add Comment
Please, Sign In to add comment