Store URL to an image

**Leesha** · 2008-03-07 18:17

Hi,

I've read numerous posts that suggest storing a web url to a photo in the sql databse vs the image itself but can find nothing on the specifics of how to do this. Am I simply storing the url that is in the source code. For example, the url is:

ImageUrl="~/App_Data/Photos/WeddingPhotos/Wedding1/1.jpg"

or is there a way to store it so that when the database is viewed the photo opens with it?

Thanks,
Leesha

**Jezza** · 2008-03-07 18:43

<img src=/S/hello.gif border=0 alt=hello width=25 height=29> Leesha

I am assuming that by your synatx, you are using ASP.NET. Correct?

**Leesha** · 2008-03-07 18:53

Hi Jerry!!! How are you??

You are good! Asp.net 2.0. Stumbled on it quite by accident due to my increasing frustration with FP limitations and the ever growing need to learn asp and now sql server 2005. Ugh.....................so much to learn! Anyway, as usual, I'm clueless but I'm certainly learning a lot! Any thoughts on this?

Leesha

**Leesha** · 2008-03-07 20:07

Thanks Jerry!! I'm encouraged in that it actually makes sense reading it, not that I could ever write it from scratch, but its no longer looking like Greek!!!

I can't wait to give it a try.

Leesha

**Jezza** · 2008-03-07 20:14

<P ID="edit" class=small>(Edited by Jezza on 07-Mar-08 19:14. To fix some syntax errors)</P>Hi Leesha

The syntax goes a bit like this:

<pre><%@ Import Namespace="System.Data.SqlClient" %>

<Script Runat="Server">

Sub Page_Load
If Not IsPostBack Then
Dim conMyData As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrImages as SqlDataReader

conMyData = New SqlConnection("Server=localhost;UID=sa;PWD=secret; Database=myData")

conMyData.Open
cmdSelect =New SqlCommand( "Select myImageURL From tblImages", conMyData)
dtrImages =cmdSelect.ExecuteReader()

rptImages.Datasource =dtrImages
rptImages.DataBind()

dtrImages.Close()
conMyData.Close()

End If
End Sub

<html>

<body>
<form Runat="Server">

<asp:Repeater
ID="rptImages"
Runat="Server">

<ItemTemplate>

<asp:Image
ImageURL='<%# Container.DataItem( "myImageURL" ) %>'
Runat="Server" />
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>
</pre>

**Jezza** · 2008-03-07 20:16

Leesha

I have made some changes to the code as I had a couple of typos in it, but fingers crossed it should assist you.

**Leesha** · 2008-03-08 14:41

Hi Jerry,
I played around with your code (thanks for your postback otherwise I'd never have found the typos LOL) and then found the imagecontrol and ended up using that which did what I needed it to. It took me forever to get the syntax correct but it finally worked. Now I'm getting errors when I go to edit the field from a form and the delete isn't working. I'll post the info to another thread.

Thanks!
Leesha

Thread: Store URL to an image

Thread Tools