i have this code but not working. image in not saving in mysql database. my platform is .net framework 3.5 so unalbe to use mysql.data.dll
Public Function insertimage(ByRef id As String)
'ExecuteSQL("Delete from TempImage")
Dim MyPathToImageFile As String
If My.Computer.FileSystem.FileExists("\\Main\Radix\SRS\student-images\" & id & ".jpg") Then
MyPathToImageFile = "\\Main\Radix\SRS\student-images\" & id & ".jpg"
Else
MyPathToImageFile = "\\Main\Radix\SRS\No Photo.jpg"
End If
Try
Dim o As System.IO.FileStream
Dim r As StreamReader
Dim jpgFile As String = MyPathToImageFile
o = New FileStream(jpgFile, FileMode.Open, FileAccess.Read, FileShare.Read)
r = New StreamReader(o)
Dim FileByteArray(o.Length - 1) As Byte
o.Read(FileByteArray, 0, o.Length)
Dim Con As New OdbcConnection(connString)
Dim Sql As String = "Insert Into TempRecPhoto (Stud_Image,Studentid) Values((?)," & id & ")"
Dim CmdObj As New OdbcCommand(Sql, Con)
CmdObj.Parameters.Add("@Image", System.Data.OleDb.OleDbType.Binary, o.Length).Value = FileByteArray
Con.Open()
CmdObj.ExecuteNonQuery()
Con.Close()
Catch ex As Exception
' MsgBox(ex.Message)
End Try
End Function