How to store and retrieve images in SQL server database through VB.NET?

Question

vijay · Answer

hi... You can try this below link For store and retrieve the stored images http://vbdotnetaddict.blogspot.com/2011/06/how-to-retrieve-uploaded-images-from.html http://vbdotnetaddict.blogspot.com/2011/02/upload-image-or-file-into-database-in.html

Muralidharan Deenathayalan · Answer

Please see our recommended articles section. http://www.c-sharpcorner.com/UploadFile/e628d9/3825/ http://www.c-sharpcorner.com/UploadFile/mamtam/AddandRetrieveImages09232005080918AM/AddandRetrieveImages.aspx http://www.c-sharpcorner.com/UploadFile/225bcd/5796/ http://www.c-sharpcorner.com/UploadFile/e628d9/3889/ Function SaveImage _ ( ByVal FileName As String ) As Integer ' Create a FileInfo instance ' to retrieve the files information Dim fi As New FileInfo ( FileName ) ' Open the Image file for Read Dim imgStream As Stream = _ fi.OpenRead ' Create a Byte array the size ' of the image file for the Read ' methods buffer () byte array Dim imgData ( imgStream . Length ) As Byte imgStream . Read ( imgData  0  fi . Length ) Dim cn As New SqlConnection _ ( ConfigurationSettings . AppSettings ( cn )) Dim cmd As New SqlCommand ( Images_ins  cn ) cmd . CommandType = CommandType . StoredProcedure With cmd . Parameters . Add ( @FileName  VarChar  100 ). Value = _ fi . Name . Add ( @FileType  VarChar  10 ). Value = + fi . Extension . Add ( @Image  Image ). Value = imgData . Add ( @FileSize  Int  4 ). Value = fi . Length End With cn . Open () cmd . ExecuteNonQuery () cn . Close () cn . Dispose () End Function Hope this helps you.