Help... Need help updating database from datagrid or dataset

Could you provide more details about the way that you bind data from the source to your controls ? Which type of databinding are you using ?
I'm not sure to understand the architecture of your database.

I've done it any number of ways.  I've binded the controls themselves directly to the attached Dataset using the designer.  I've also pulled the database into a dataset in seperate named tables and attached the controls to the datatables.  IN this case I've used the sqlDataAdapter.  I've also used access for the database. Imagine I have a people table, cars table, houses table.  THe people can have any number of houses or cars.  In my form, the designer initially created a nav bar control with the main table being the people table.  In 2 tabs on the form, I have one for cars and one for houses.  Inside the cars tab, is the fields from the cars datatable.. say ID (pk) | PeopleID (FK) | CarType | PurchasedDate.  Say Car Type refers to a seperate cars type table.  

How would I update the cars datatable and post that to the database.  or for that matter, how does one figure out how to change anything that has changed, been deleted or updated.. cars / houses or whatever?

I just used a simple example so I can understand it and hopefully apply this to my real projects.

For each different table I certainly have ONE binding only. Then if the data binding is correctly performed, each time something happen to the data in the DB that must be reflected on your display.
Whatever what happen on the GUI I suppose that you handle all the events, for example if the user presses the "del" key on the keyboard you have a function behind that is doing something.
So there is no magic way. Each time something happen you have process the event idividually and calculate which SQL query must be done on which data source.
You should have one dataset with several tables inside, for example, and update it by taking into account the links that exist between different tables. Each controls binded to the tables should be automatically updated.
Your question relates on your DB architecture perhaps.

I'm not quite sure I understand what you're saying.  Are you saying that I should have a save button for each table and save them individually?

I'm not saying that you should have a save button, I just supposed that you provide something to the users to change the data. I just don't know how is made your GUI since you're telling so few about your app so I'm oblidge to make some suppositions... and since you're economizinf the info so everything is confusing to me.

But forget these buttons stories.
"How do I update information stored on multiple tables" => each time you want to change data in a table you have to calculate the impact on the others.

Do you have an example of what you mean?  Lets assume that I have the following table:

Employees
ID (PK) | Name | EmployerID (FK) | Phone | Address


EmployerID
ID (PK) |  CompanyName

Certification
ID (PK) |  Certification

EmployeeCertification
ID (PK) | Certification.ID | EmployeeID

So If I have one form.  The main section of that form is the Employees Information (name, address, phone)..  I was thinking of a tab object to hold the Certification Data.  

So the user has to enter all this information about the employee into the database.  If it is only name,address, phone -- its saved and updated no problem.  But because its relational, what is the best way to save all the related tables?    I've heard some people using transactions, some doing everything manual, etc.. I want the easiest way to handle saving related tables in one screen.

Joe