i have a new program i want put the 13 chapter database ,the table picture.in the table ,the field imageurl's value is ~gagpics\filename.jpg. i want get the physical path c:\begaspnet\site\gagpics\filename.jpg how can i do

I want to ask the transformation path problem
for exaple
~gigpics\filename.jpg transformation c:\begaspnet\site\gigpics\filename.jpg or
~gigpics\filename.jpg transformation to d:\1\filename.jpg
mymail :
[email protected] i come from china ,sorry my english

Hi there,

You can loop through the data (using ADO.NET, or Linq to SQL or Entity Framework), grab the path and replace the ~ with a hardcoded path. If you want to make the change in the database you can also use REPLACE in T-SQL to change the ` to a path.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!