Control to Display Binary Images in ASP.NET

��SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Test]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Test](

	[TestId] [int] IDENTITY(1,1) NOT NULL,

	[TestName] [nvarchar](50) NULL,

 CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED 

(

	[TestId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ImageTest]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[ImageTest](

	[ImageId] [int] IDENTITY(1,1) NOT NULL,

	[ImageTitle] [nvarchar](50) NULL,

	[ImageContent] [image] NULL,

 CONSTRAINT [PK_ImageTest] PRIMARY KEY CLUSTERED 

(

	[ImageId] 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]

END

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertNewImageTest]') AND type in (N'P', N'PC'))

BEGIN

EXEC dbo.sp_executesql @statement = N'-- =============================================

-- Author:		<Author,,Name>

-- Create date: <Create Date,,>

-- Description:	<Description,,>

-- =============================================

CREATE PROCEDURE [dbo].[InsertNewImageTest]

	-- Add the parameters for the stored procedure here

	@ImageTitle nvarchar(50),

	@ImageContent image

AS

BEGIN

	Insert Into ImageTest ( ImageTitle,ImageContent) values (@ImageTitle,@ImageContent)

END

' 

END