Type of value has a mismatch with column typeCouldn't store in PICTURE Column. Expected type is Byte[].

Question

0.00/5 (No votes)

See more:

VS2008

hello fellow coders
am new at vb
i have been able to save a picture and other data, in a access database and am able to display it in the picturebox ,but am unable to Edit the picture,i can edit all the other data but when it comes to pictures it gives me this error,
"Type of value has a mismatch with column typeCouldn't store <system.drawing.bitmap> in PICTURE Column. Expected type is Byte[]"
here's my code for editing

Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
Dim cb As New OleDb.OleDbCommandBuilder(da)
If inc <> -1 Then
ds.Tables("hip").Rows(inc).Item(1) = txtidNumber.Text
ds.Tables("hip").Rows(inc).Item(2) = txtFirstName.Text
ds.Tables("hip").Rows(inc).Item(3) = txtMiddleName.Text
ds.Tables("hip").Rows(inc).Item(4) = txtSurName.Text
ds.Tables("hip").Rows(inc).Item(5) = cboGender.Text
ds.Tables("hip").Rows(inc).Item(6) = txtLocation.Text
ds.Tables("hip").Rows(inc).Item(7) = txtPhone.Text
ds.Tables("hip").Rows(inc).Item(8) = txtEmail.Text
ds.Tables("hip").Rows(inc).Item(9) = txtNotes.Text
Dim bytes As [Byte]() = ds.Tables("hip").Rows(inc).Item(10)
Dim ms As New MemoryStream(bytes)
picPhoto.Image = Image.FromStream(ms)
ds.Tables("hip").Rows(inc).Item(10) = picPhoto.Image------(ERROR HERE)---"Type of value has a mismatch with column typeCouldn't store <system.drawing.bitmap> in PICTURE Column. Expected type is Byte[]"
da.Update(ds, "hip")
MsgBox("DATA EDITED")
End If
End Sub

Posted 30-Nov-13 3:52am

Member 10436009

Add a Solution

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 · Accepted Answer · 2013-11-30T04:02:00

Solution 1

The error message is pretty explicit: "Type of value has a mismatch with column type Couldn't store in PICTURE Column. Expected type is Byte[]"
You are passing an Image to a column that expects an array of bytes. So try converting the Image to a byte array:

VB

Dim ms As New MemoryStream()
picPhoto.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp)
ds.Tables("hip").Rows(inc).Item(10) = ms.ToArray()

Posted 30-Nov-13 4:02am

OriginalGriff

Comments

Member 10436009 30-Nov-13 10:15am

it worked but here is the problem i have to log out so that the program can accept changes that i have given it is there a way or code i can add so that there immediate changes are inserted into it,your help would be highly appreciiated

OriginalGriff 30-Nov-13 10:18am

Sorry? That doesn't make any sense to me - remember I can't see your screen, access your HDD or read your mind: so I only get what information you give me, not any background context.

Member 10436009 30-Nov-13 10:38am

ok lemme explain what am saying,after i have saved,edited or deleted the data from the database,it keeps on appearing on the windows form until i exit or close the windows form,when i load it again is when the data deleted disappears,the data saved shows or the data edited shows. in short the changes i make or made doesn't appear untill i have exited and loaded the form again.

OriginalGriff 30-Nov-13 10:43am

The code you show doesn't deal with any display controls - so you need to explain exactly how the code above is related to to the display. There are a huge number of different ways you could be doing this, and I don't like to guess! ;)

Member 10436009 30-Nov-13 10:59am

ok