title: using repeater control to display an image from database C#
body: <p>I have a book database(2 books in total right now) where for each book i have a row called 'Image' that contains the name of the images.
  For example. cprog.jpeg and asm.jpeg</p>
  
  <p>Using the repeater i can display the book information like name, author, etc. But i dont know how to get the images to display. The images are stored in the images folder.</p>
  
  <p>here is the aspx which is the issue? since, it displays the bookname and description just fine.</p>
  
  <pre><code>&lt;asp:Repeater ID="Repeater1" runat="server"&gt;
          &lt;ItemTemplate&gt;
   &lt;%# DataBinder.Eval(Container.DataItem, "BookName") %&gt;
   &lt;hr&gt;
   &lt;%# DataBinder.Eval(Container.DataItem, "BookDescription") %&gt;
   &lt;td width="100px"&gt;
    &lt;p align="left"&gt;
  
  
   &lt;img src= '&lt;%# DataBinder.Eval(Container.DataItem, "Image") %&gt;.jpeg'  
   alt="" style="height:200px;width:200px;border:1px solid gray;"/&gt;
  
    &lt;/td&gt;
    &lt;/p&gt;
  </code></pre>
  
  <p>
    
      <br>
    
              </p>
  
  <p>Code behind</p>
  
  <pre><code>String connectionString = "Data Source=" + Server.MapPath(@"~\App_Data\bookDB.db");
          String selectCommand = String.Format("Select * from Book where CategoryName = '{0}'", Request.QueryString);
          SQLiteConnection myConnection = new SQLiteConnection();
          myConnection.ConnectionString = connectionString;
          myConnection.Open();
          SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(selectCommand, myConnection);
  
          myConnection.Close();
          // DataSet ds = new DataSet();
          dataAdapter.Fill(ds2);
  
  
          DataTable table = new DataTable();
          dataAdapter.Fill(table);
          Repeater1.DataSource = table;
          Repeater1.DataBind();
  </code></pre>
  
  <p>Once, when i ran the project the broken image appeared for a second and then disappeared. I have spent the last 2 days trying to get this with no avail...
  Thank you.</p>