How can I load Images from sql sqrver & show it in a control.
Note that I want to know whitch control can do it?
In web app please but not win app.
thanks.

You can use the <asp:Image> control, or the plain old HTML img tag.

The trick to binding it to your datasource, is to place the image control inside the ItemTemplate of a Repeater, and bind the Repeater to a list of image URLs which are stored in your database.

The repeater could look like this sample from "ASP.NET Unleashed".

<asp:Repeater


  ID="rptImages"


  Runat="Server">





<ItemTemplate>


<br>


<asp:Image


  ImageURL='<%# Container.DataItem( "image_url" ) %>'


  Runat="Server" />


</ItemTemplate>





</asp:Repeater>

my filed type is image(in sql server)
I want to load stream of bytes from sqldb to Image control.
byte[] pictre = -->load from db
ImageControl. ? = ?
!!!

Only way I know of is using an ashx (or something similar). The thing is: you need an url in order to display an image in the browser. You feed it a unique identifier for the image you want and then serve it up. Security can get funny when you don't want people to access any old picture (by trying identifiers for instance). You'll then need to check access rights in your ashx.

I have some code, but it's not that general and I don't want to take time to make it that.

This might be an example:
http://aspalliance.com/articleViewer.aspx?aId=141
Uses an aspx page instead of ashx to retrieve the image, but oh well.
http://msdn.microsoft.com/msdnmag/issues/02/08/WickedCode/
Shows an example of how to use http handlers (ashx).

You can use BinaryImage from http://asplib.net

This control supports next way to show a image:

img.Binary = (byte[]) dr["Image"];

How I remember they have free version of this control.