Click here to Skip to main content
14,114,975 members
Click here to Skip to main content
Add your own
alternative version


136 bookmarked
Posted 25 May 2006
Licenced CPOL

Rating Demystified: Ajax Way, Amazon Way*

, 16 Aug 2008
Rate this:
Please Sign up or sign in to vote.
Ever wondered, how the amazon rating system works with multiple items in the same page, here is a simple article to describe the basic bare bones needed to create an asynchronous rating module using ASP.NET , SQL Server and ..... AJAX

Ajax Rating System
New Window Online demo - Ajax Rating (updated)

New Window Get the Rating Web Widget (new)


This article describes an ASP.NET web module along with some chunks of Javascripts and ...Ajax to create a Rating System. This can be added /customized for any table to add a rating/score module. I was quite amazed, when i first saw the capability of rating multiple items at amazon website without refreshing the page. That nice piece of functionality followed me like destiny, till i needed to implement it in a web application.

Well ! putting it in a live scenario needs much more than just javascript. I started with a bit of frenzied hacking. To understand how exactly it works, by scanning the javascript from online asynchronous rating websites. That was just the beginning, on the way i learned much more than earlier imagined. Here is the result of the effort.

The target was to create a cross browser rating/score system like amazon or better:

  1. Rating: User should be able to Rate a record (1-5)
  2. Accuracy: Number of votes and total score should be accurate and saved and should not be lost in calculations
  3. Real time: Rate/score should be displayed after rating instantly
  4. Reusable: It should be easily plugged into any table for reusability
  5. Avoiding multiple ratings: Basic mechanism to avoid multiple ratings by the same user
  6. Best approach: Compare the pros and cons for both Amazon and Ajax approach
  7. Security: Few words

* By Amazon Way i meant it can simulate the rating system like the amazon website, it does not claims that this is the way amazon is doing there rating.

In Action

To hold your interest, here is how it will look (for single record), once completed

Rating in Action


Those were the initial thoughts, but to make it a general reusable and extensible module, I made some assumptions:

  • The table which will have the records to be rated will have a Primary Key ID (integer and identity) and the it will be the first field in the table.
  • The Table will have atleast two Fields: RatedBy & Score
  • For the current example to work you will need atleast one extra field Title

Rating table structure

Rating Table

web.config structure

The web.config has four keys, one for the connection string and the other for the name of the fields for RatedBy (for the number of user who rated the record) and Score (For total Score) and the table from which you want to apply the Rating system.


Required images ( included with the source)

Final Scores

Final Scores Stars

Pretty self explainatory final score can be in decimals 1, 2.5, 2, 4.5 etc, though while rating the images should be only 1-5


These are the actions which make the whole module:

  • Data access
  • Create rolling mouseover rating images
  • Rating Amazon way, Ajax way
  • Saving asynchronously using IFrames like Amazon (needs refresh)
  • Saving asynchronously using AJAX (no refresh)
  • Rating multiple items in the same page
  • Basic security, rating for an item can be done only once by the user

Data access class

There is a standard data access class, clsDataAccess.cs, which handles all the data related actions.

Code: I have kept here only the names of the functions, just to give you a glimpse of the data access methods.

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient; 

namespace Rating
    public class clsDataAccess
    // Class defination
        public clsDataAccess()
        { }
        SqlConnection mycon = new SqlConnection(
        // Opens database connection with in SQL SERVER
        public bool openConnection()
        // Closes database connection with in SQL SERVER
        public void closeConnection()
        // Getdata from the table required(given in query).
        public SqlDataReader getData(string query)
        // Save data usually,inserts and updates the data in table.
        public void saveData(string query)
        // Save data usually,inserts and updates the data.
        public void saveNewData(string query)
        // Delete data in database depending on the tablename.
        public int DeleteData(string query)
        // Get data by paging using datagrid.
        public SqlDataAdapter getDataforUpdate(string query)
        // Get data by paging using datagrid.
        public DataSet getDatabyPaging(string query)
        // check a particular value to see the validity.
        public int getCheck(string query)
        // Get a value of limit from the database table.
        public string getValue(string query,int j)
        //Log in method 
        public SqlDataReader Login(string query)
        // dynamically get all table names
        public DataTable getTablenames()
        // For Table operations
        public int TableWrite(string query)

Creating rating Images with mouse over:

Stars to Rate

For this we need set of five images for the stars and five for the comments as shown above and two javascript function DisplayStars and DisplayMsg to display those images on mouseover.


function DisplayStars (id, rating)
     var starID = "stars." + id;
     starTwinkler[id] = 0;
     msgTwinkler[id] = 0;
     document.write("<map name='starmap" + id +"'>");
     var i = 0;
     for (i = 1; i < 6; i++) {
     document.write("<area shape=rect " + 
     "coords='" + starMap[i] + "' " +
     "onMouseOver=\"StarMouseOver('" + id + "'," + i + ");\" " +
     "onMouseOut=\"StarMouseOut('" + id + "');\" " +
     "onClick=\"SaveStars('" + id + "'," + i + ");" +
     "\" >");
 document.write("<img vspace=2 title = 'Rate Picture' src='" 
 + starImages[rating] + "'");
 document.write(" border=0 usemap='#starmap" + id);
 document.write("' id='" + starID + "'>");
function DisplayMsg (id, rating)
     var msgID = "messages." + id;
if ( rating == undefined ) {
document.write("<img vspace=2 height=11 src='" + nullStarMessage + "'");
     else {
 document.write("<img vspace=2 height=11 src='" + starMessages[rating] + "'"); 
 document.write("' id='" + msgID + "'>");

Javascript Mouseover functions are so old that nothing needs to be explained.You will also need functions for MouseOut OnClick, Initalize images etc, included in the source.

Rating: Amazon Way

Rating:Single Amazon uses IFrames So the whole process of rating actually happens in another page which resides in the current page through iframe. Rate.aspx is the page which will be called inside an IFrame to call the Rating function
<iframe width="310" height="28" src="Rate.aspx?id=" frameborder="0" bgcolor="#F2EFE0" />


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

You may also be interested in...

Comments and Discussions

NewsIframe Way (aka Amazon), error in Cons Pin
Drofnas30-May-06 7:22
memberDrofnas30-May-06 7:22 
AnswerRe: Iframe Way (aka Amazon), error in Cons Pin
Raj Lal30-May-06 7:40
memberRaj Lal30-May-06 7:40 
GeneralOops Pin
leppie28-May-06 4:28
memberleppie28-May-06 4:28 
GeneralRe: Oops Pin
Raj Lal28-May-06 9:41
memberRaj Lal28-May-06 9:41 
GeneralRe: Oops Pin
leppie28-May-06 10:19
memberleppie28-May-06 10:19 
GeneralRe: Oops Pin
RK KL30-May-06 0:42
memberRK KL30-May-06 0:42 
AnswerRe: Oops Pin
Raj Lal30-May-06 9:25
memberRaj Lal30-May-06 9:25 
AnswerRe: Oops [modified] Pin
Raj Lal30-May-06 9:23
memberRaj Lal30-May-06 9:23 
GeneralGood job, but... Pin
FredericSivignonPro26-May-06 2:22
memberFredericSivignonPro26-May-06 2:22 
AnswerRe: Good job, but... Pin
Raj Lal26-May-06 7:21
memberRaj Lal26-May-06 7:21 
JokeRe: Good job, but... [modified] Pin
FredericSivignonPro28-May-06 6:12
memberFredericSivignonPro28-May-06 6:12 
GeneralRe: Good job, but... [modified] Pin
leppie28-May-06 10:09
memberleppie28-May-06 10:09 
GeneralRe: Good job, but... [modified] Pin
Raj Lal28-May-06 11:18
memberRaj Lal28-May-06 11:18 
GeneralNice Pin
NormDroid25-May-06 21:13
professionalNormDroid25-May-06 21:13 
GeneralRe: Nice Pin
Raj Lal26-May-06 11:03
memberRaj Lal26-May-06 11:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web06 | 2.8.190518.1 | Last Updated 16 Aug 2008
Article Copyright 2006 by Raj Lal
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid