how to display images ?

shirley65 · May 31st, 2004, 05:32 AM

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
  string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
  strConnection += @"Data Source=C:\BegASPNET\ch12\Northwind.mdb";
  data_src.Text = strConnection;
  string strSQL = "SELECT FirstName,LastName, LinkPicture FROM Employees";
  string strResultsHolder = "";
  OleDbConnection objConnection = new OleDbConnection(strConnection);
  OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection);
  OleDbDataReader objDataReader = null;
  try
  {
    objConnection.Open();
    con_open.Text="Connection opened successfully.<br>";
    objDataReader = objCommand.ExecuteReader();
    while (objDataReader.Read() == true)
    {
       strResultsHolder += objDataReader["FirstName"];
       strResultsHolder += " ";
       strResultsHolder += objDataReader["LastName"];
       strResultsHolder += "<br/>";
    }
    objDataReader.Close();
    objConnection.Close();
    con_close.Text = "<br/>Connection closed.<br/>";
    divListEmployees.InnerHtml = strResultsHolder;
  }
  catch (Exception e)
  {
    con_open.Text = "Connection failed to open successfully.<br/>";
    con_close.Text = e.ToString();
  }
}
</script>
<html>
  <body>
  <h4>Reading data from the connection
  <asp:label id=data_src runat=server/> with the DataReader object.</h4>
  <asp:label id=con_open runat=server/><br>
  <div id="divListEmployees" runat="server">list will go here</div>
  <asp:label id=con_close runat=server/><br>
  </body>
</html>

This code from: chapter 12, Beginning ASP.NET 1.0 with C#.NET, WROX, datareader.aspx, let me retrieve data from a database and display them on the same page containing the code.
But how should I modify the code if one of the column of my database ( I called it LinkPicture) was a text-file, that is a path pointing to a .jpg file, and I wanted display that image with the other data on the same datareaader.aspx page?
Or should I use another code altogether!
Many Thanks Shirley65

jacob · May 31st, 2004, 06:41 AM

As far as I can see a quick solution would be something like this...

Code:

while(objDataReader.Read() == true)
{
   strResultsHolder += objDataReader["FirstName"];
   strResultsHolder += "&nbsp;";
   strResultsHolder += objDataReader["LastName"];
   strResultsHolder += "&nbsp;";
   strResultsHolder += "<img src='" + objDataReader["LinkPicture"] + "' />";
   strResultsHolder += "<br/>";
}

(not tested)

However I would probably use e.g. tables to structure the elements better, or use placeholders in the aspx page. Furthermore there is classes that enables you to add elements dynamically, so you do not have to construct the HTML string manually.

Hope it helps

Jacob.

shirley65 · May 31st, 2004, 08:12 AM

many many thanks
shirley