Comments by kef ngunjiri

kef ngunjiri 8-Jan-14 7:16am View

I am sorry it still has the same problem,pls help.

kef ngunjiri 8-Jan-14 6:51am View

iam new in vb how do you call the method pls explain

kef ngunjiri 28-Nov-13 9:57am View

wow it's that simple thanks both of u

kef ngunjiri 28-Nov-13 9:26am View

iam trying to put the code, but a syntax error at
byte[] data = (byte[]) dt.Rows[0]["IMAGE"];
it says
'Byte' is a type that cannot be used as an expression

kef ngunjiri 28-Nov-13 8:44am View

iam new to vb can u please elaborate how is should add this statement
byte[] data = (byte[]) dt.Rows[0]["IMAGE"];
MemoryStream ms = new MemoryStream(data);
pictureBox1.Image = Image.FromStream(ms);
which i got from this link http://stackoverflow.com/questions/3440366/how-can-i-convert-system-byte-to-image-c-window-forms
i don't know how to put it in the code

kef ngunjiri 28-Nov-13 8:22am View

Deleted

iam new to vb can u please elaborate how is should add this statement
byte[] data = (byte[]) dt.Rows[0]["IMAGE"];
MemoryStream ms = new MemoryStream(data);
pictureBox1.Image = Image.FromStream(ms);
which i got from this link
http://stackoverflow.com/questions/3440366/how-can-i-convert-system-byte-to-image-c-window-forms
i don't know how to put it

kef ngunjiri 26-Nov-13 14:34pm View

yap i did that i deleted all the original data that was there. that's and it brought or is there another way of navigating pictures? that i can apply i would really appreciate if u even gave me a hint

kef ngunjiri 26-Nov-13 12:41pm View

yes it has worked(it has retrieved the picture)
i have a little problem i have saved several data and pictures(like several records)
and i want to navigate through records (that is move from one record to another(move to next,previous )including pictures),i can navigate through data but it brings the same problem that is 'parameter is invalid'
here is the code for navigation
Private Sub NavigateRecords()
Dim da As New OleDb.OleDbDataAdapter("SELECT*FROM CONTACTS", con)
Dim dt As New DataTable
da.Fill(dt)
If ds.Tables("PEOPLE").Rows.Count > 0 Then
txtAgentNumber.Text = ds.Tables("PEOPLE").Rows(inc).Item(1)
txtFirstName.Text = ds.Tables("PEOPLE").Rows(inc).Item(2)
txtMiddleName.Text = ds.Tables("PEOPLE").Rows(inc).Item(3)
txtSurName.Text = ds.Tables("PEOPLE").Rows(inc).Item(4)
cboGender.Text = ds.Tables("PEOPLE").Rows(inc).Item(5)
txtAddress.Text = ds.Tables("PEOPLE").Rows(inc).Item(6)
txtPhone.Text = ds.Tables("PEOPLE").Rows(inc).Item(7)
txtEmail.Text = ds.Tables("PEOPLE").Rows(inc).Item(8)
txtNotes.Text = ds.Tables("PEOPLE").Rows(inc).Item(9)
retrieve()
ds.AcceptChanges()
End If
End Sub
when i click next button or previous button
the invalid parameter error
Sub retrieve()

Using con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\PEOPLE.mdb")
con.Open()
Using cmd As New OleDbCommand("SELECT PICTURE FROM CONTACTS WHERE AGENTNUMBER='" & txtAgentNumber.Text & "'", con)
Dim imageobj = cmd.ExecuteScalar
If Not imageobj Is Nothing AndAlso Not imageobj Is DBNull.Value Then
Using ms As New System.IO.MemoryStream
Dim bm As Bitmap
Dim byteArray = DirectCast(imageobj, Byte())
ms.Write(byteArray, 0, byteArray.Length - 1)
bm = New Bitmap(ms)
picPhoto.Image = bm------ the error appears here
End Using
End If
End Using
End Using
End Sub

kef ngunjiri 26-Nov-13 11:44am View

ok let me try

Comments by kef ngunjiri (Top 9 by date)