Friday, March 23, 2012

How do I insert a pic in sql then bind it to a control

Hi want to add a pic to the my details table.

I then want to bind this to a repeater.

eg

<asp:Repeater id="rp1" runat="server">
<itemtemplate>
<%#Container.DataItem("PIC)"%>
</itemtemplate>
</asp:Repeater
how can i do this? what would i need to do in sql and what format would it have to be in etc. ThanksHere's an article that Das wrote on how to do that:Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET

Also, search this forum for the word "Image" and you will see some lengthy discussions on the topic. Basically, previously the wisdom had been to store the images in the file system and then you store the file name in SQL. But there are advantages to doing it the way you are describing.

Terri

No comments:

Post a Comment