C# How to Upload Image & Store in Database

Question

Hello i would like to find out how can i find upload and store an image to the database. Im uning C# asp.net in Visual Studio 2012. what is the datatype for the image in database and how to call in in the coding?

Upendra Pratap Shahi · Answer

Hello, Go through below link- http://www.c-sharpcorner.com/UploadFile/77a82c/open-another-gridview-in-pop-up-using-bootstrap-modal-pop-up/

Abhishek Singh · Answer

Hi There Rajeev, You can have datatype as SqlDbType .Image for storing the data. You can use below code to insert... SqlCommand cmd = new SqlCommand("INSERT INTO YourTable(ImageID,ImageName,Image) VALUES (@ImageID,@imagename,@image)", connection); cmd.Parameters.Add("@imagename", SqlDbType.int).Value = ImageID; cmd.Parameters.Add("@imagename", SqlDbType.VarChar, 50).Value = imagename; cmd.Parameters.Add("@image", SqlDbType.Image).Value = Image; int count = cmd.ExecuteNonQuery(); Hope thsi will help. Abhishek

Raja T · Answer

Hi Rajveer, http://simplyaspnet.blogspot.in/2013/08/how-to-save-images-in-database-and.html http://www.aspsnippets.com/Articles/Save-Files-to-SQL-Server-Database-using-FileUpload-Control.aspx http://csharpdotnetfreak.blogspot.com/2009/07/fileupload-control-save-images-database.html

Dev sharma · Answer

Hi Rajveer, Please follow this http://www.aspsnippets.com/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx

Raja T · Answer

http://www.codeproject.com/Articles/482800/FileplusUploadplusinplusUpdateplusPanel

Raja T · Answer

hi, Please check http://www.codeproject.com/Articles/1757/File-Upload-with-ASP-NET

C# How to Upload Image & Store in Database

Answers (6)