Creating DB with drop down lists and update button

Hey guys, I'm going to try to explain what I'm trying to accomplish and see if someone can push me in the right direction whether it be an explanation, tutorial, etc.

Here goes, I want to create a Gridview where one of the columns contains a drop down list. The drop down list would have a shown value and an underlying data value. The shown value would be, say, 'QB' (its a football game) and the underlying value would be '10' (this is the value that sorts the gridview, RB = 11, and so on). The user would be able to go in and change his starting lineup by selecting the drop down lists and changing values.

Then I would need a 'Save Changes' button that would then initiate the updates to all the changed values.

I hope that all makes sense. If anyone has played fantasy football on Yahoo! by any chance, that is basically what I'm trying to recreate.

For the record I am using Visual Web Developer Express, SQL 2005. I already have the gridview, but cant figure out how to put drop down lists inside my grid. Also, would I need to make an extra table for just the drop down list values? Lastly, I do not know how to make a Save Changes type button. I would assume a button with a little code behind it, but it's that code thing that gets me sometimes!

Guys, thanks for all your help...not just now, but in the past. This is easily the best board on the web to receive great help!

 

You can use templates to drop your custom content in, they work great and are easy to test with.
As for where the data will come from for the combo, you can pull that from a query on any available table.

Here's a really simple example you can expand on, with a sample project D/L:
http://blogs.msdn.com/robburke/archive/2005/04/01/404727.aspx