http://www.codeproject.com/cs/database/relationaladonet.asp
Inserting relational data using DataSet and DataAdapter
By Mauricio Ritter
This article describes the process of inserting data in a DataSet and then submitting this changes to the database. It targets the issue when having IDENTITY/AutoNumber columns in the database.