Home Home Home
Click to learn how to rotate images dynamically with the ASP.NET Image Control
    Step by Step ASP.NET Design Solutions
The Ultimate Website Design Guide Using ASP.NET and Adobe Photoshop

Rotate Images using ASP.NET and SQL Server

It's always important for your website visitors to see fresh content. One simple way to do this to have a set of images display on a page that change each time the page is visited or refreshed. Nearly any type of website web site could benefit from this type of dynamic content. You've probably seen animated .gif images before but those can be large files which will impact page-load performance.

This website is using this very feature in the ASP.NET Master Page to rotate the scenic picture in the upper right corner of the page. Our site is only rotating one picture at a time. However we've designed other sites to use this feature to show multiple pictures. This Lesson has the following steps:

Step 1. SQL Server table and stored procedure

First we create a table called "gallery_images". Open SQL Server and open a new query window in your database. Cut and paste the following SQL statement below to create a table called "gallerly_images". This table will store our data about the images that we want to display. The "Img" field will store the url to the image on the web site. For example "/images/rotate/rotate1.jpg"

CREATE TABLE [dbo].[Gallery_Images](
	[ImageID] [int] IDENTITY(1,1) NOT NULL,	
	[Img] [varchar](50) NULL,
	[imgH] [int] NULL,
	[imgW] [int] NULL,
	[Dttm] [datetime] NULL,
 CONSTRAINT [PK_Gallery_Images] 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]

Now manually upload some images to a folder on your site. In our example we'll be using /images/rotate/ and then enter the urls to the images into the gallery_images table we created. Be sure to add 5-6 images.

After adding some data your table should look similar to this with different image names naturally.

SQL Table for storing images

Next keeping an eye on security and performance we'll create a SQL Server stored procedure to query the images from the table we just created. Be sure to assign execute permissions for this stored procedure to the sql login that your web site uses to query the database.

Create PROCEDURE [dbo].[sp_images_random]

 AS

select top 1 img as 'url' from gallery_images 
order by newid() desc

Being good programmers we always test our code on the database before hooking it into a web page so manually execute the store procedure we just created in a query window

SQL Server Stored Procedure to query random images

Next Lesson

In Step 2. ASP.NET Image Control we'll setup an ASP.NET page using the ASP.NET Image Control to store the results of our query.

Privacy Policy Copyright © 2010 dotnetdesignguide.com  Webmaster  Sponsored by www.portable-computer-keyboard.com