User-1538122812 posted
Hello ,
I am building a mobile application using vb.net with an oracle 11g mobile server .
I am storing a client's signature in a BLOB in the database. I want to show the signature on interface as a bitmap image.
I have used the following code , but it gives me an exception :
Private Sub LoadPod()
Dim dsn As String = "dsn=PDA_OLITE_PUB;uid=aa;pwd=bb"
conn = New Oracle.DataAccess.Lite.OracleConnection(dsn)
cmdSel = New OracleCommand
cmdSel = conn.CreateCommand
Dim sql As String = "SELECT delevn_sign , delevn_date, delvnt_no ,sig_blob FROM trk_delivery_events WHERE delevn_status='OK' and delvnt_no='" & tracking.DeliveryNo & "'"
conn.Open()
cmdSel.CommandText = sql
cmdSel.Connection = conn
cmdSel.Prepare()
Dim SQLreader As IDataReader
SQLreader = cmdSel.ExecuteReader()
While SQLreader.Read()
txtRecipientName.Text = SQLreader.GetString(0)
txtPODdatetime.Text = SQLreader.GetString(1)
Dim bytes As OracleBlob
bytes = (SQLreader.GetValue(3))
Dim byteArr As Byte() = New Byte(bytes.Length - 1) {}
Dim mStream As System.IO.MemoryStream
mStream = New System.IO.MemoryStream()
Dim pData() As Byte = DirectCast(byteArr, Byte())
mStream.Write(pData, 0, Convert.ToInt32(pData.Length))
Dim bm As Bitmap
bm = New Bitmap(mStream)
pbRecSig.Image = bm
End While
cmdSel.Dispose()
conn.Close()
End Sub
This is the part where the exception occurs : " bm = New Bitmap(mStream) "
It gives " out of memory exception "
What's wrong with that code? Any ideas? Please help me guys
Thank you in advance .
