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.

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

Answers (2)