i'm beginner on visual basic 2008. i'm designing a database for my personal use, however i need to use one image for each one raw of my database, so i created a column named "images" and in data type "image". my problem is that in other columns i can directly write depending of the data type (by example on nvarchar (50)), but i don't know how insert directly or indirectly each one image for each raw.
thanks
Loading
CrishPosted Nov 30, 2010, 5:37 AM
I had same problem . To solve this problem you can go for below link.
http://www.vbdotnetheaven.com/UploadFile/rohatash/3876/Default.aspx
Hirendra SisodiyaPosted Oct 21, 2010, 4:11 AM
Private Sub FindImageInByte()
Dim oFile As System.IO.FileInfo
oFile = New System.IO.FileInfo(Filename)
Dim oFileStream As System.IO.FileStream = oFile.OpenRead()
Dim lBytes As Long = oFileStream.Length
If (lBytes > 0) Then
Dim fileData(lBytes - 1) As Byte
oFileStream.Read(fileData, 0, lBytes)
oFileStream.Close()
SaveToDB(fileData)
End If
End Sub
Private Sub SaveToDB(ByVal memStreamOrg As Byte())
Dim sqlConn As New SqlClient.SqlConnection
sqlConn.ConnectionString = "Put your connection string"
sqlConn.Open()
Dim Command As New SqlClient.SqlCommand("Insert into tblImage (Image_Temp) values( @PicOrig )", sqlConn)
Dim PicOrig As SqlClient.SqlParameter
PicOrig = New SqlClient.SqlParameter("@PicOrig", SqlDbType.Image)
PicOrig.Value = memStreamOrg
Command.Parameters.Add(PicOrig)
Command.ExecuteNonQuery()
sqlConn.Close()
End Sub
thanks
Hirendra SisodiyaPosted Oct 21, 2010, 4:10 AM
sql image column accept only binary data, you you need to convert image into byte() data.
thanks