I've developed an application to do many things with multiple thread .
now the remaining things are done-able but im stuck in new requirement posted by Client which he needs to upload all images from Sql Server to Oracle Database now since old application stores images Path it is kind of new story now ?(:
i tried to build sample application since am not familiar with kind of above requested modification here is my code so far to upload images but i do not know what is wrong ?
'' Sql connection is over Dim fs as new fileStream (imgPath , io.fileMod.Open , Io.FileAccess.Read) Dim imgByte (fs.length -1 ) as byte fs.Read (imgByte , 0 , ImgByte.length) if imgByte.Length > 0 then Con.open cmd.Connection = Con cmd.CommandType= CommandType.Text Dim Cmd as new Sqlcommand ( " Insert into Demo values (" & imgByte & ") ") else msgbox ("Image not uploadable !") end if
Please any help or hint !!
also note that i need to save images locally from SQL server and then upload it to Oracle DB
Please help me with link or code !
(: thank you