LOADING IMAGE FROM DATABASE

Question

1.00/5 (3 votes)

See more:

THE CODE IS TO LOAD IMAGE FROM TABLE "STAFFPICS" AND IS GIVING PROBLEM AT"

PictureBox1.Image = Image.FromStream(stmSTAFF_PICS)

PICS)PICS)" SAYING INVALID PARAMETER.HELP ME OUT

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
       Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Users\BELLCONSULT\Documents\COUNCILS.mdb"
       Dim cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(strConnection)
       cn.Open()

       Dim dd As New OleDb.OleDbCommand("select STAFF_PICS from STAFFPICS where F_NO =" & Val(TextBox2.Text), cn)
       Dim dr As OleDb.OleDbDataReader = dd.ExecuteReader()
       dr.Read()
       If dr.HasRows Then
           Dim byteSTAFF_PICS(dr.GetBytes(0, 0, Nothing, 0, Integer.MaxValue) - 1) As Byte
           dr.GetBytes(0, 0, byteSTAFF_PICS, 0, byteSTAFF_PICS.Length)
           Dim stmSTAFF_PICS As New IO.MemoryStream(byteSTAFF_PICS)
           PictureBox1.Image = Image.FromStream(stmSTAFF_PICS)

       End If
       dr.Close()

   End Sub

Posted 23-May-13 20:38pm

adesewa

Updated 24-May-13 8:47am

v2

Add a Solution

Comments

OriginalGriff 24-May-13 3:31am

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-05-23T21:31:00

Solution 1

Normally, this means you saved it wrong:
Why do I get a "Parameter is not valid." exception when I read an image from my database?[^]

Posted 23-May-13 21:31pm

OriginalGriff

Comments

adesewa 24-May-13 14:48pm

i didnt get ur comment pls.

OriginalGriff 24-May-13 15:06pm

Follow the link.
The chances are you saved the wrong data to your database, so when you try to retrieve the image, you get an error. The link explains what you need to do to fix your save-image code.

adesewa 25-May-13 15:53pm

i dont understand that i saves wrong data into the database

OriginalGriff 25-May-13 16:25pm

What code did you use for the save?
[edit] Bloody auto predictive text! 'Coffee' for 'code'[/edit]

adesewa 27-May-13 8:06am

This code load the picture from system to picturebox on the form:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim OpenFileDialog1 As New OpenFileDialog
With (OpenFileDialog1)
.CheckFileExists = True
.ShowReadOnly = False
.Filter = "All Files|*.*|Bitmap Files (*)|*.bmp;*.gif;*.jpg"
.FilterIndex = 2
If .ShowDialog = Windows.Forms.DialogResult.OK Then
' Load the specified file into a PictureBox control.

PictureBox1.Image = Image.FromFile(.FileName)
If PictureBox1.Image.Width > 100 Or PictureBox1.Image.Height > 100 Then
MessageBox.Show("YOUR PICTURES MUST BE 100 X 100 ")
End If
End If
End With

End Sub

This code is used to save data into STAFFPICS Table
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim ms As New IO.MemoryStream
PictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat)
Dim arrImage() As Byte = ms.GetBuffer

Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Users\BELLCONSULT\Documents\COUNCILS.mdb"
Dim cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(cnString)
cn.Open()
Dim SSQL As String = "INSERT into STAFFPICS(F_NO,STAFF_PICS) VALUES('" & TextBox1.Text & "','" & arrImage.ToString & "')"
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(SSQL, cn)
cmd.ExecuteNonQuery()
cn.Close()
MessageBox.Show("THANKS")

End Sub

OriginalGriff 27-May-13 8:30am

Here is a little bit of free advice for you: When you are given a link which says "never concatenate strings to form SQL commands" because it will cause the problem you are describing, if you totally ignore it you are probably doing the wrong thing.

Read the link. Then do what it says. I know it's in C# but it's exactly the same principle: in this case all you have to do, pretty much, it remove the semicolons.