Retrieve image from database

Question

I have saved image in varbinary datatype in sql server. Instead of showing its binary format i want to see actal image in sql server console as a output.

so if anyone know how can i retrieve image in sql server commands or anything??

plz help mee. 

 

Answer 1

Hi,

Try using below links :-

 

http://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/

http://dotnettutorials.com/tutorials/database/save-retrieve-image-cs/

https://www.aspsnippets.com/Articles/Inserting-and-Retrieving-images-from-SQL-Server-database-without-using-Stored-Procedures.aspx

 

Hope it helps...

Answer 2

Please refer this:

 

http://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/