How convert tilde (~) path the full website url

Question

In the database we are storing paths, like "~/SubDir/2015/A/B/1.jpeg".

How do I easily convert that to my full website url, like http://www.mywebsite.com/SubDir/2015/A/B/1.jpg?

http://stackoverflow.com/questions/3681052/get-absolute-url-from-relative-path-refactored-method — Marc, Apr 13 '16 at 20:31
Possible duplicate of [Getting full URL from URL with tilde(~) sign](http://stackoverflow.com/questions/9092523/getting-full-url-from-url-with-tilde-sign) — Vadim Martynov, Apr 13 '16 at 20:34
Trying to use it as the image source for an asp.net image control. — WebDevGuy2, Apr 13 '16 at 20:42
I don't want to do a straight string.Replace because I could be on the dev machine (locahost) or the production server. I want to know the correct way to do this. Thanks — WebDevGuy2, Apr 13 '16 at 20:46
It is still a correct way if you have a base address of application stored in config (correct way again). — Nikhil Vartak, Apr 13 '16 at 21:14

IrishChieftain · Answer 1 · 2016-04-13T20:47:49.550

1

If you are creating img links, add the runat="server" attribute for the links to resolve correctly:

<img src="~/SubDir/2015/A/B/1.jpeg" alt="Desc" runat="server" />

This will then display images whether you are on a development, staging or production server...

edited Apr 13 '16 at 20:47

answered Apr 13 '16 at 20:31

IrishChieftain

score 0 · Answer 2 · answered Apr 13 '16 at 20:32

0

You need to know the value you want to replace.

You could do it in SQL with the REPLACE() function, e.g.

SELECT REPLACE(ColumnName, '~', 'http://www.mywebsite.com') FROM Table

Or do it in C#:

string url = url.Replace("~", "http://www.mywebsite.com");

answered Apr 13 '16 at 20:32

Dan Field

2 Answers2