How to call a file path from a sql server database but not show it?

Question

1.60/5 (2 votes)

See more:

I am using a string to store the file path of an image in a sql server database. I want to call the file path from the database in a vb.net winform project but not show it because I want to just show the image. Can anyone advise me on how to do this? Thanks in advance for your help.

EDIT:

Just to be clear, the image path is stored as a string in the database from one form, I want to call the path in another form, but I don't want to show the path, I want to show the actual image the path points to.

Posted 8-Aug-14 3:15am

Member 10804519

Updated 8-Aug-14 3:40am

v2

Add a Solution

2 solutions

Solution 2

You can simply put a 'PictureBox' control to your form and set its 'ImageLocation' property with the URL you are getting from database itself. This will take care to display the image from the specified path.

Ex :-

C#

pictureBox1.ImageLocation = @"D:\SMRUTI\Projects\CodeProjTest\TestApp2-Win\Images\chat1.jpg";

Hope this will definitely of help to resolve your issue.

Posted 8-Aug-14 4:23am

SRS(The Coder)

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)

Member 10804519 · Accepted Answer · 2014-08-08T03:48:00

Solution 1

By using the following line of code I was able to solve my problem.

VB

pbImage.Image = Image.FromFile(CStr(dtPersons.Rows(0).Item(3)))

Posted 8-Aug-14 3:48am

Member 10804519