<img> from database... How??

arganaz · November 17th, 2006, 12:33 PM

yes, it's true, i appear to be dumb.
i've been looking around and cant understand/find how to store and retrive html tag ( and standard text) from and onto a database. i want to do pages where my father can just update is site, with no computer knowledge. Can anyone suggest where to start from? My main worry is how to display the image tag <img>, are here any examples outthere, can i do it with no or little code?

Thank you,
Paulo

davidrodrigues40 · November 17th, 2006, 01:00 PM

I did something similar to this using the fileupload control. Save the file to a folder and place the file path and name into the database as the images url. Then place a gridview on the page and place an asp:image tag in the column/templaste with the imageurl bound to the returned url of the image. Let me know if this help or you need further assistance.

David Rodrigues
"There is no box"

arganaz · November 20th, 2006, 05:55 AM

Thank you for your answer, but I think I didnât explain myself right, what I need is a way to display html already stored on a database (as text) on an aspx.
The code would have been inserted on the database, using an online (WYSIWYG) html editor.
(He might want to use tables for positioning, images on diferent positions, etc...)
Thanks,
Paulo

arganaz · November 20th, 2006, 06:58 AM

ok, nevermind, I got it... if I use:
<%@ Page Language="VB" AutoEventWireup="True" ValidateRequest="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
    Sub SubmitBtn_Click(ByVal sender As Object, ByVal e As EventArgs)
        Span1.InnerHtml = "You wrote: <br />" + TextArea1.Value
    End Sub
</script>
<html >
<head>
   <title>HtmlTextArea Example</title>
</head>
<body>
   <form id="form1" runat="server" style="border-right: maroon thin dotted; border-top: maroon thin dotted; margin: 2px; border-left: maroon thin dotted; width: 250px; border-bottom: maroon thin dotted; height: 250px;">
      <h3>HtmlTextArea Example</h3>
      Comments: <br />
      <textarea rows="2" cols="20" id="TextArea1"
                runat="server"/>
      <br />
      <input id="Submit1" type="submit"
             value="Submit"
             onserverclick="SubmitBtn_Click"
             runat="server"/>
      <br />
      <span id="Span1"
            runat="server" style="" />
   </form>
</body>
</html>

I can get what i need, BUT i have to insert om the textarea : img src="images/image.jpg" (with the opening and closing < > ), I was trying to use ~/ or / before the image folder and forgoting to set ValidateRequest="false".
Well i hope this helps others, questions? post them. Thanks David, for the help.

Cheers,
Paulo