image retrieve from database

It might be helpful,

SQL Database Image Storage & Easy Thumbnails[^]

Retrieving Image from SQL Database in C#[^]

:)

This is exactly what you want :
Storing binary data in SQL Server using EF[^]

Table for store image

CREATE TABLE [dbo].[atul](
[id] [int] IDENTITY(1,1) NOT NULL,
[img] [image] NULL,
CONSTRAINT [PK_atul] PRIMARY KEY CLUSTERED
(
[id] ASC
)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO





Store procedure for retrieve image

create PROCEDURE [dbo].[ReadImage] @imgId int

AS
BEGIN

SET NOCOUNT ON;

SELECT img FROM atul
WHERE id=@imgId
END






code for display image which stored in sql-server through selected image-id

string i=txtimg.text;// image id
SqlCommand cmd = new SqlCommand("ReadImage", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@imgId", SqlDbType.Int).Valu
Convert.ToInt32("i");
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{

byte[] imageData = (byte[])dt.Rows[0]["img"];
Response.BinaryWrite(imageData);


}