How to insert an image in to database ?

Question

am using sql server 2008 R2.. i need to insert an image through sql cmd ? my table structure is SELECT TOP 1000 [AddressID] [Image] FROM [xxx].[dbo].[tblAddress] how can i insert an image where AddressID='1' ?

Munesh Sharma · Answer

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

Raja T · Answer

Hi Joginder Banger  Its Ok

Raja T · Answer

Hi Ruga Lincy  Please show me the results screen bellow query SELECT TOP 1000 [AddressID] [Image] FROM [xxx].[dbo].[tblAddress] Are you store the image with binary format or storing the imagepath etc. Kindly share the above query results screen.

Rajeesh Menoth · Answer

Hi Kindly check this article : click here

Ruga Lincy · Answer

SELECT TOP 1000 [AddressID] [Image] FROM [xxx].[dbo].[tblAddress] how can i insert an image where AddressID='1' ? can anyone write insert image for above table

Ruga Lincy · Answer

Msg 4861 Level 16 State 1 Line 2 Cannot bulk load because the file C:\Users\system 1\Desktop\Desk\xxxx.jpg could not be opened. Operating system error code 3(The system cannot find the path specified.).

Ruga Lincy · Answer

Msg 4861 Level 16 State 1 Line 2 Cannot bulk load because the file C:\Users\system 1\Desktop\Desk\xxxx.jpg could not be opened. Operating system error code 3(The system cannot find the path specified.).

Joginder Banger · Answer

sorry Bro if you mine I mean your code some hide how can read this so i request check answer design before post the answer. _jsb

Raja T · Answer

Hello Joginder Banger  Before i was posting there is no hit for this post.

Joginder Banger · Answer

Hi Raja Please improve your answer Please see answer before hit the post button. _jsb

Joginder Banger · Answer

Hi Ruga Lincy I think image store in database is a bad thing. If you store image store any folder and save only name of image. It's very cool and easy trick. I assume your images size around 2MB. after some time your database very Heavy. Best of Luck _jsb

Raja T · Answer

Hi Please checkout bellow url http://blogs.msdn.com/b/walzenbach/archive/2010/05/20/how-to-insert-binary-data-like-images-documents-into-a-sql-server-database-with-sql-server-management-studio.aspx /* Insert a new category with an image */ INSERT INTO Categories ( CategoryName  CategoryPicture ) Values ( 'Another Category'  ( SELECT * FROM OPENROWSET ( BULK N'C:\Temp\ AnotherCategory .jpg'  SINGLE_BLOB ) AS CategoryImage ))

Ruga Lincy · Answer

insert an image through sql cmd manually ??

Upendra Pratap Shahi · Answer

Hello Kindly go through below link- http://www.c-sharpcorner.com/UploadFile/77a82c/binding-image-with-gridview-and-update-image-in-gridview/