SQL String Data Parsing

<p>

Hi everybody, I was hoping to get some advice something I can't quite get my head around.  I have a SQL db which contains a table with ratings using the AJAX rating control.

When someone rates an object, I need to select the current rating and then use those numbers to;

- calculate the new average

- add new score to total score

- increment number of votes by one.

 

I thought this can be best achieved using the SELECT statement and then parsing the SELECT string. (is the string comma separated?)

using each array, i'd need to convert this into integers and then do the calculation. and re-upload the data to the ratings table (using the UPDATE statement).

 

Is this the best way of proceeding?  I have tried initially to write the code using three sql statements. But that would mean to many requests from the server, right?

Below is the conde I have writting already.int myrating;

myrating = Rating1.CurrentRating;string getscore = "SELECT " +

"RatingScore" +"FROM Rating " +

"WHERE ItemID= '" + _ItemID+ "'";string getcount = "SELECT " +

"RatingCount" +"FROM Rating " +

"WHERE ItemID = '" + _ItemID + "'";string getaverage = "SELECT " +

"RatingAverage " +"FROM Rating " +"WHERE ItemID = '" + _ItemID + "'";

 

int _ratingscore;int _newscore; _ratingscore = int.Parse(getscore);

_newscore = _ratingscore + myrating; //add new rating score to old scoreint _ratingcount;

int _newcount;_ratingcount = int.Parse(getcount);

_newcount = _ratingcount + 1; //increase count by 1int _ratingaverage;

int _newaverage;_ratingaverage = int.Parse(getaverage);

_newaverage = _newscore / _newcount; //calculate new average rating

 otherwise

 otherwise would i be best off to do the following?...

string[] dbRatings = SQLstring.Split(',');

 ??

Any help would be appreciated.

Many thanks in advance.

Phil

 

</p>