Loading

how to save image link in table and retrieve from table in s

krunal pande

8y1k

hi team,

how to save image link in table and retrieve from table in sql server.

for e.g

CREATE TABLE ##Images(

[ID] [int] IDENTITY(1,1) NOT NULL,

[ImageData] varBinary(max) NOT NULL

)

insert into ##Images(ImageData)

select convert(VARBINARY(MAX),'https://zinghrnewux.blob.core.windows.net/wishes/MINS/Birthday/Final.jpg')

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nakul Chaudhari8y ago
http://www.dotnetgallery.com/kb/resource21-How-to-store-and-retrieve-images-from-SQL-server-database-using-aspnet.aspx.aspx
Ankit Sharma8y ago
Hi Krunal,

Please refer to these links. You can find SQL queries here

https://www.aspsnippets.com/Articles/Save-and-Retrieve-Files-from-SQL-Server-Database-using-ASPNet.aspx

http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html

Hope this helps