images from a database using reference

blagynchy · Apr 28, 2012

I know this is probably a simple question, but I can't see how to do it. I have the web address of an image stored (e.g http://www.mysite.com/image.gif) in SQL Server and would like to display the image in my web page (I am using C#). Can anyone help?? Many thanks Jamiefirst, nothing is easy (at least for me) in .NET =) But I hope this helps. <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.IO" %> <html> <title>Templated Columns - Images</title> <style> a {behavior:url(....mouseover.htc);} hr {height:2px;color:black;} .StdText {font-family:verdana;font-size:9pt;font-weight:bold;} .StdTextBox {font-family:verdana;font-size:9pt;border:solid 1px black;filter

rogid

XImageTransform.Microsoft.dro pshadow(OffX=2, OffY=2, Color='gray', Positive='true');} .Shadow {filter

rogid

XImageTransform.Microsoft.dropshad ow(OffX=2, OffY=2, Color='gray', Positive='true');} iframe {border:solid 1px black;filter

rogid

XImageTransform.Microsoft.dro pshadow(OffX=2, OffY=2, Color='gray', Positive='true');height:220px;} </style> <script runat="server"> public void Page_Load(Object sender, EventArgs e) { // Initialize only the first time... if (!Page.IsPostBack) { lblURL.Text = Request.Url + "<hr>"; } } public void OnLoadData(Object sender, EventArgs e) { UpdateView(); } public void PageIndexChanged(Object sender, DataGridPageChangedEventArgs e) { grid.CurrentPageIndex = e.NewPageIndex; // Refresh the grid UpdateView(); } private bool IsImageAvailable(String strLastName) { String strImageFile = "images\" + strLastName + ".bmp"; return File.Exists(Server.MapPath(strImageFile)); } private void UpdateView() { SqlConnection conn = new SqlConnection(txtConn.Text); SqlDataAdapter da = new SqlDataAdapter(txtCommand.Text, conn); DataSet ds = new DataSet(); da.Fill(ds, "MyTable"); // Bind the data grid.DataSource = ds.Tables["MyTable"]; // Display the data grid.DataBind(); } </script> <body bgcolor="ivory" style="font-family:arial;font-size:small">  <h2>Editing Columns with Images</h2> <asp:Label runat="server" cssclass="StdText" font-bold="true">Current path: </asp:label> <asp:Label runat="server" id="lblURL" cssclass="StdText" style="color:blue"></asp:label> <form runat="server"> <table> <tr> <td><asp:label runat="server" text="Connection String" cssclass="StdText" /></td> <td><asp:textbox runat="server" id="txtConn" Enabled="false" cssclass="StdTextBox" width="700px" text="DATABASE=Northwind;SERVER=localhost;uid=sa;passwor d=;" /></td></tr> <tr> <td><asp:label runat="server" text="Command Text" cssclass="StdText"/></td> <td><asp:textbox runat="server" id="txtCommand" Enabled="false" width="700px" cssclass="StdTextBox" text="SELECT employeeid, titleofcourtesy, firstname, lastname, hiredate, title, notes, country FROM Employees" /></td></tr></table> <asp:linkbutton runat="server" text="Go get data..." onclick="OnLoadData" /> <hr> <asp

ataGrid id="grid" runat="server" AutoGenerateColumns="false" CssClass="Shadow" BackColor="white" CellPadding="2" CellSpacing="0" BorderStyle="solid" BorderColor="black" BorderWidth="1" font-size="x-small" font-names="verdana" AllowPaging="true" PageSize="4" DataKeyField="employeeid" OnPageIndexChanged="PageIndexChanged"> <AlternatingItemStyle BackColor="palegoldenrod" /> <ItemStyle BackColor="beige" VerticalAlign="top" /> <EditItemStyle BackColor="yellow" Font-Bold="true" /> <PagerStyle Mode="NumericPages" /> <HeaderStyle ForeColor="white" BackColor="brown" HorizontalAlign="center" Font-Bold="true" /> <columns> <asp:BoundColumn runat="server" DataField="employeeid" HeaderText="ID"> <itemstyle backcolor="lightblue" font-bold="true" HorizontalAlign="right" /> </asp:BoundColumn> <asp:TemplateColumn runat="server" HeaderText="Employee Name"> <itemtemplate> <asp:label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "TitleOfCourtesy") + " " + DataBinder.Eval(Container.DataItem, "LastName") + "" + ", " + DataBinder.Eval(Container.DataItem, "FirstName") %>' /> </itemtemplate> </asp:TemplateColumn> <asp:TemplateColumn runat="server" HeaderText="Photo"> <itemtemplate> <img runat="server" width="50" visible='<%# IsImageAvailable(DataBinder.Eval(Container.DataIte m, "lastname").ToString()) %>' src=http://aspmessageboard.com/archive/index.php/'<%# "images/" + DataBinder.Eval(Container.DataItem, "lastname") + ".bmp" %>' /> <asp:label runat="server" text="No picture available." visible='<%# !IsImageAvailable(DataBinder.Eval(Container.DataIt em, "lastname").ToString()) %>' /> </itemtemplate> </asp:TemplateColumn> </columns> </asp

ataGrid> <asp:label runat="server" id="lblCurrent" /> </form> </body> </html>

images from a database using reference

blagynchy

New Member