Fetch the image url from SQL Server database to display an image

Question

I have a column in my database that stores the url of the user's profile picture. In the home page' page_load event handler, I need to determine the image url, but I don't know how to do that using SQL commands.

From the images below, how can I give the query result to the image's ImageUrl property?

enter image description here

Check this post and hope this will help you: aspsnippets.com/Articles/… — Paresh J
– Paresh J, Commented Apr 16, 2015 at 4:22

Sriram · Accepted Answer · 2015-04-16 07:08:47Z

1

You can use Server.mappath("~/profilepicture/profilepicture.jpg")

OdbcDataReader reader=new OdbcDataReader();
reader=command.executereader;
    Profilephotobutton.imageur=server.mappath(" & reader.item(profilepicture) & ");

hope this helps

edited Apr 16, 2015 at 7:08

answered Apr 16, 2015 at 6:23

Sriram

7397 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sriram Over a year ago

its just a datareader you have to execute your sql command in a datareader then you have to get the value ex: odbcdatareader=command.executereader;

Collectives™ on Stack Overflow

Fetch the image url from SQL Server database to display an image

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related