Image Editing and Saving

aliirfan84 · May 27th, 2007, 03:58 AM

I want to save image in datase(Oracle 10g) from ASP.Net application. Please tell me how to save it in binary?

Also is there any way to make changes in image from APS.Net page and to save it?

Regards
Ali Irfan

thenoseknows · May 27th, 2007, 09:01 PM

I think you would need to convert your image file into a byte array and store that in Oracle as whatever oracles varbinary or image equivalent is (equivalent to SQL Server that is). I haven't used Oracle for a few years but I think I remember they had BLOB (binary large object) for that sort of thing.

I am thinking something like this:

Code:

Imports System.Data.Odbc
Imports System.IO

...

Dim imgFileByteArr() As Byte
imgFileByteArr = File.ReadAllBytes("/Path/To/Image/imageFile.jpg")
Dim cmd As OdbcCommand = New OdbcCommand()
Dim p As New OdbcParameter("test", OdbcType.Binary)
p.Value = imgFileByteArr
cmd.Parameters.Add(p)

aliirfan84 · May 28th, 2007, 12:12 AM

Thanks.

But can u tell me how can I pass it in Insert Query directly instead of passing it using Stored Proc.

Also plz let me know that wether I can edit image(mean can change color of image) in ASP.Net page and then save back into DB?

Regards
Ali Irfan