I have a form and on the form are basically a bunch of textboxes. I dropped a sqldataadapter on the form and connected to my data. It created a binding source and my controls are all bound to it. When I start the form I get my first record and I can navigate throughout the database. When I make a change, it is stored in my dataset but that does not update the sql server. When I close the form and reopen, all my changes are gone. Where should I be updating the database (as I navigate, each record or when closing the form), and how?