Show image from sql on non javascript link

Question

Hi say of have a table of cars in my SQL database. That table has a column for the car make and a column called picture of type:

Picture(image, null)

I'm then displaying my cars in a repeater and so it might look like this:

<asp:Repeater id="carsRepeater" runat="server" DataSourceID="CarsDataSource>
  <HeaderTemplate>
    <table>
  </HeaderTemplate>
  <ItemTemplate>
    <tr>
      <td>
        <asp:Label id="carMakeLabel" runat="Server" Text='<%# Eval("Make") %>' />
      </td>
      <td>
        Some how display a clickable image here
      </td>
    </tr>
  </ItemTemplate>
  <FooterTemplate>
    </table>
  </Footer>
</asp:Repeater>

What I'm wanting is in column two to get the picture of the car to display and make it so you can click on that picture and it will run a method in the code behind. Also I have this requirement where the picture click method mustn't require javascript to run.

Can someone please give me an idea of how I would go about this?

I'm currently thinking about putting the image somehow in a link but I'm not sure how to display the image. Maybe the asp:Image but that requires an ImageUrl.

Martyn · Accepted Answer · 2011-02-22 22:57:36Z

1

Try image button, it displays an image, doesn't require javascript and you can run a method on click event from code behind

answered Feb 22, 2011 at 22:57

Martyn

451 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Coder 2 Over a year ago

Thanks, but I'm unsure how to set the image to this button given it's not coming from a file location but from sql.

amit_g · Accepted Answer · 2011-02-22 23:06:20Z

0

Write an HTTPHandler (say CarImage.ashx) and in that handler, given ID of the image return the binary data with ContentType of image/gif (or whatever). Render an image tag in the datagrid with src as CarImage.ashx?ImageID=xxxxx. The process is described many place including this one.

answered Feb 22, 2011 at 23:06

amit_g

31.3k8 gold badges67 silver badges125 bronze badges

Collectives™ on Stack Overflow

Show image from sql on non javascript link

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related