Best way to get database images from Web Service

Posted on 2010-08-27
Medium Priority
Last Modified: 2013-11-07
I'm working on a mobile web site and web service where the images are stored in the database. For the web site, I'm using the following markup to display a stored image:
<img id="MyImage" runat="server" EnableViewState="false"
    src='<%# Eval("ImageFileID", "~/HttpHandlers/DBImageHandler.ashx?fileid={0}") %>' alt=""

Open in new window

But other web sites may call my web service and need access to the stored images. Should I just have the web method return the ResolveURL value of "~/HttpHandlers/DBImageHandler.ashx?fileid={0}" or is there a better way?

Or is it sufficient if I just return the ImageFileID and document how the caller should make use of that information?

Thanks in advance.
Question by:ZekeLA
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 31

Accepted Solution

MlandaT earned 500 total points
ID: 33548343
Should I just have the web method return the ResolveURL value of "~/HttpHandlers/DBImageHandler.ashx?fileid={0}" or is there a better way?
I think yes... however... remember that other sites WILL NOT BE ABLE to use the "~/HttpHandlers" as it refers to your machine... pretty much like 'localhost'... so perhaps rather return the full url including the domain name e.g. http://www.mydomain.com/HttpHandlers/DBImageHandler.ashx?fileid=1
LVL 16

Expert Comment

by:Vikram Singh Saini
ID: 33548810

Why don't you create a WebMethod in WebService which takes the Id from client to retrieve image from database. And then return the byte array of the image back to the client. And on the client side in your web application use those byte array values in MemoryStream to retrieve image from the same.

Why ? Because no need of providing clients the URL as some of malicious user can misuse them. (It's my assumption only, your choice to accept it or not).


Author Comment

ID: 33549492
That's what I meant to say MlandaT when i said I would use ResolveURL. I realize I have to give them the rendered URL. I appreciate the confirmation.

VSS, that's what the handler does. But the client could be almost anything; it won't necessarily be be .NET. How well can other platforms take an array of bytes back and convert it into an image?

Author Comment

ID: 33549503
My other issue was making the web method result small. Returning just the FileID is less than providing the entire url. But it requires the client to create the image's url. And it isn't flexible if our website organization changes. I could always put the base url in a returned soap header so it only gets sent once per call.
LVL 16

Assisted Solution

by:Vikram Singh Saini
Vikram Singh Saini earned 500 total points
ID: 33549547

I agree with comment at ID:33549492. I was thinking that in .Net context. But for comment at ID:33549503 you said that if our website organization changes. For that you can save your images url in database along with file id. And so when you changes organization update those url values in database.


Featured Post

Tutorials alone can't teach real engineering

So we built better training tools.

-Hands-on Labs
-Instructor Mentoring
-Scenario-Based Tests
-Dedicated Cloud Servers

All at your fingertips. What are you waiting for?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question