G
Guest
Does anyone knows how to CAST this SQL Response into a MemoryStream ??
When executing below code an error message says "Specified cast is not valid"
I need to put this into MemoryStream to use it into imgPhoto
Dim imgPhoto As System.Drawing.Image =
System.Drawing.Image.FromStream(myStream)
Dim dbConn, SQLStmt, dbComm, dbRead, img
Dim myStream 'As New MemoryStream
dbConn = New
System.Data.OleDb.OleDbConnection(Application("connection_string"))
dbConn.Open()
img = "picture1"
SQLStmt = "SELECT figura "
SQLStmt = SQLStmt & "FROM figura_tb "
SQLStmt = SQLStmt & "Where nome = "
SQLStmt = SQLStmt & "'"
SQLStmt = SQLStmt & img
SQLStmt = SQLStmt & "'"
dbComm = New System.Data.OleDb.OleDbCommand(SQLStmt, dbConn)
dbRead = dbComm.ExecuteReader()
If dbRead.read() Then
myStream = dbRead("figura")
End If
When executing below code an error message says "Specified cast is not valid"
I need to put this into MemoryStream to use it into imgPhoto
Dim imgPhoto As System.Drawing.Image =
System.Drawing.Image.FromStream(myStream)
Dim dbConn, SQLStmt, dbComm, dbRead, img
Dim myStream 'As New MemoryStream
dbConn = New
System.Data.OleDb.OleDbConnection(Application("connection_string"))
dbConn.Open()
img = "picture1"
SQLStmt = "SELECT figura "
SQLStmt = SQLStmt & "FROM figura_tb "
SQLStmt = SQLStmt & "Where nome = "
SQLStmt = SQLStmt & "'"
SQLStmt = SQLStmt & img
SQLStmt = SQLStmt & "'"
dbComm = New System.Data.OleDb.OleDbCommand(SQLStmt, dbConn)
dbRead = dbComm.ExecuteReader()
If dbRead.read() Then
myStream = dbRead("figura")
End If