Display image on pictureBox using the image path stored on DB [Solved/Closed]
mikeoe200325
Posts Thursday November 1, 2012Registration date
March 27, 2014
Last seen
-
Nov 21, 2012 at 03:30 AM - Latest reply: umesh
- Feb 9, 2017 at 04:11 AM
Hello,
when I run a select query I wan the the picture box on the form to display image of the File path stored in the database table. please I need help
Paste the below mentioned code in the Click event of ButtonSelect:
Dim cnn As New OleDb.OleDbConnection
cnn = New OleDb.OleDbConnection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Databasemikeoe2003PictureApplication.mdb;"
If cnn.State = ConnectionState.Open Then
cnn.Open()
End If
Dim da As New OleDb.OleDbDataAdapter("SELECT * FROM Tablemikeoe2003PictureApplication WHERE Id = " & TextBoxPictureID.Text, cnn)
Dim dt As New DataTable
da.Fill(dt)
Me.TextBoxPictureFilePath.Text = dt.Rows(0).Item("PicturePath")
cnn.Close()
Superb. I was puzzled for this.Found many option but not worked even complicated also
But you done the superb job. Heads off to you
quite smile
Thank you soo much
thanks for this help
but my picture can display only when i copy full path from folder, but when i use it the datagridview by getting pic name from datagridview, it becomes error.
has helped 1810 users this month
But you done the superb job. Heads off to you
quite smile
Thank you soo much
thankyou