Image file insertion into Database

[shaiful]

Hi All,
I tried a lot also followed many previous example, still i cant get proper idea that how to insert an image file into database? I using VB and Access. for example:
My File image file is "C:\test\x.dwg", I want to insert into table test(img, ID) . Please help me if u can, Thanks advance, Sam

[debasisdas]

You need to convert the file into byte stream and store in database file.

[debasisdas]

Please find the details here.

[shaiful]

Hello, thanks very much for ur valuable reply, However I cant understand which one is the image fime and which field of table will keep ? Sorry Just if more clear idea abt that, Thx

[QVeen72]

Hi,

Check This Out

The Code is for Oracle (Long Raw datatype)
For Access, Field datatype is : OLE Data

Regards
Veena

[debasisdas]

Hello, thanks very much for ur valuable reply, However I cant understand which one is the image fime and which field of table will keep ? Sorry Just if more clear idea abt that, Thx

strFileNm is th ename of the file
logo is the name of the field in database table.

for oracle datatype should be lob or long raw
for access datatype should be ole