Hi:
I want to create a simple example of taking information from the database and putting it into a variable for use in code.
Example: There is a row in a three field database: id=3, name=Jane Smith, debit balance=65.
I want it so that when she clicks a check box for an item that costs 50, it will go to the database (it knows her id is 3 so it will go to the row with the 3), and it will pull off the information, including the 65, so when it does the subtraction, it can see that she has enough money and it will proceed with the transfer.
What I need: I need to get that number 65 into a variable.
In PHP, we search the database and with a query and get the row with id=3, and store that information in an array. From there, there is a PHP way to pull out what was in the field "debit balance", and put that into a variable.
If I can do the same thing with ASP.NET 2.0 (from database to something to variable), I think I have it.
What I'm looking for: if you can give me a few key words for the "tools" or "things" that I need, that's it. For example, when I started, someone told me "you want to do that with an SqlDataSource, a GridView and a FormView." I like looking things up--I just need to know what to look up. Thanks in advance.
-Larry
(I give green checkmarks when someone answers my question 
)
Start with something simple that works.