I have a RadioButtonList that has four values 1, 2, 3, and 4. Which are saved in a Banking column in an SQL database. When the user selects one of the four values I need the code behind to check the Banking column and determine if that particular value has been selected more that 10 ten times (by other users stored in the database) and if so display a message to the user asking them to make another choice.

What would be the best way to accomplish this?

rdove84

Hi

The best approach would be to determine this count in the stored procedure, if count is more that 10 return a value, else you can simply update it in the database.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

Another question, if I make the change in the stored procedure it won't actually make the check until the user hits the submit button, yes? Or do I need to write a new procedure that could be called each time a user makes a selection?

rdove84