display image in gridview from DB where database has image URL not image [Resolved]

Posted by Rickeybglr under ASP.NET on 8/6/2012 | Points: 10 | Views : 16498 | Status : [Member] | Replies : 4
Hi,

i want to display photo with some info store in DB. DB has only image URL not the image. images are stored in asp.net folder.
suggest guys...
i got idea..tht we can map image column to image URL. to retrieve image url with data i have written the SP.




Responses

Posted by: Ranjeet_8 on: 8/6/2012 [Member] [MVP] Gold | Points: 50

Up
0
Down

Resolved
       

<asp:TemplateField HeaderText="Image">
<ItemTemplate >
<asp:Image ID="Image1" runat="server" ImageUrl ='<%#eval("ImageURL_ColumnName") %>' height="120px" Width="150px" />
</ItemTemplate>
</asp:TemplateField>


Rickeybglr, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vforvijay on: 8/6/2012 [Member] Starter | Points: 25

Up
0
Down
Hi..
Refer the below link to view the image using URL form db
http://www.dotnetcode.in/2011/06/how-to-store-imageurl-in-database-and.html

Rickeybglr, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shailesh21235 on: 8/6/2012 [Member] Starter | Points: 25

Up
0
Down
here first you need to set the path of your folder in which folder you have stored image. Than imagename stores the name of your photo from database than you simply can retrive the photo from database using imagename.
string path = Server.MapPath(("~/Admin/Images/" + fileuploadImagepath.FileName).ToString());
string imagename = Path.GetFileName(fileuploadImagepath.PostedFile.FileName);

Rickeybglr, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rickeybglr on: 8/6/2012 [Member] Starter | Points: 25

Up
0
Down
Thnks everyone ..

Rickeybglr, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response