I have a Form and some controls bound to DataConnector. I have to scroll through the records update a few but when I close the form, all my changes are lost. I have tried using the dataConnector.EndEdit() but it doesn't do anything. How do you update the actual database?

You need to call Update on the TableAdapter. The TableAdapter is automatically generated when you set up data binding using the designer.