Display image on pictureBox using the image path stored on DB [Solved/Closed]
mikeoe2003
- Posts
- 25
- Registration date
- Thursday November 1, 2012
- Last seen
- March 27, 2014
Related:
- Display image on picturebox using the image path stored on db
- How to set browser to display images - How-To - Web Browser
- Google Chrome- Disable the display of images files - How-To - Google Chrome
- How to display image in c program ✓ - Forum - Programming
- Outlook -how to display images automatically - How-To - Outlook
- Visual Basic.net -Saving image path to an Access database - How-To - Programming
2 replies
Best answer
Hi mikeoe2003,
Create a form with the controls shown in the below mentioned image:
http://img43.imageshack.us/img43/4668/formsh.jpg
Create a Database with the name Databasemikeoe2003PictureApplication.mdb (see the image below for the design of the Database):
http://img846.imageshack.us/img846/6905/databaseb.jpg
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()
PictureBox1.Image = System.Drawing.Bitmap.FromFile(TextBoxPictureFilePath.Text)
Run the application and check for the results.
Do reply with results.
Create a form with the controls shown in the below mentioned image:
http://img43.imageshack.us/img43/4668/formsh.jpg
Create a Database with the name Databasemikeoe2003PictureApplication.mdb (see the image below for the design of the Database):
http://img846.imageshack.us/img846/6905/databaseb.jpg
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()
PictureBox1.Image = System.Drawing.Bitmap.FromFile(TextBoxPictureFilePath.Text)
Run the application and check for the results.
Do reply with results.
A few words of thanks would be greatly appreciated. Add comment
4337 users have said thank you to us this month
But you done the superb job. Heads off to you
quite smile
Thank you soo much
thankyou