Inserting Photo/image from VB to SQL server

[pravalika]

hi friends,

i am using VB as a front end and SQL server as a backend.

i want to know how to insert photo/image of an employee entry form into sql Server database(table).

and after inserting successfully all employee details , when i search on EMP_ID how to display particualr employees photo/image from database.

thanks in advance
bye

[JHausmann]

Image data types usually represent GIF's or JPEGs. Image values inserted into a table must be prefixed with 0x in an insert statement, Image data types cannot be an odd number of bytes (if the size is > 255 bytes)and will pad a 0 on if it is. You cannot reference an image field in a where statement, it cannot be part of an index cannot be used in ORDER BY, COMPUTE or GROUP BY statements and cannot be used as a local variable.

And I always wondered why I never used them ....