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 1633 users this month
But you done the superb job. Heads off to you
quite smile
Thank you soo much
thankyou