Images into table via SQL

Question

Hi would appreciate a SQL way (NOT via any dev. lang. code) of getting a table populated with images. I can use pathnames or BLOBS into the table.. as long as the image is then visible when I databind. Thanks in advance

Vijaya Kadiyala · Answer

Hi Check out the below link http://www.java2s.com/Code/SQLServer/Insert-Delete-Update/InsertingImages.htm Thanks Vijaya Kadiyala Http :// dotnetvj . blogspot . com

Vijaya Kadiyala · Answer

HI Agree with Raul that is best way is to save the path. But onething we need to handle is what is we change the Image File Location?? Should we update the table with the path?? Thanks -- Vijaya Kadiyala

Raul · Answer

i think that the best way is to save a path where is image into sql

Vijaya Kadiyala · Answer

Hi I am glad to see you got the answer... Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com

Manuel B · Answer

Very interesting. Thanks a lot for the link. Ciao

Lisa · Answer

i doubt there isnt any way to do it in TSQL you can just retrieve and save them. it should be done progrmatically by getting the values from the database. Thanks Lisa

Manuel B · Answer

Hi is there no way in SQL via some TSQL command or SQL utility? Thanks

Mahesh Chand · Answer

Store or save images in SQL Server database using C#