I'm pretty sure I remember Bonnie posting an example in C# in an earlier thread to you (maybe 2-3 weeks ago). I would check that out. Basically, you will loop through all the records in your DataTable, check their version, and handle it based on that.

Ok, looking back on Bonnies examples, I now have this. Again, it compiles and doesn't error, but the data doesn't
make it to the back end. The new row is in the data set. What am I doing wrong here???

/*****************************************************
 * Get the customer record 
******************************************************/

string sSelectCommand = "select * from Customers where CustomerKey = 1";

SqlDataAdapter oDataAdapter = new SqlDataAdapter(sSelectCommand, oConnection);
DSCustomer oDataSet = new DSCustomer();
oDataAdapter.Fill(oDataSet, "DSCustomer");

/*****************************************************
 * Or Create a new blank data set record 
******************************************************/
//DSCustomer oDataSet = new DSCustomer();

// Add a blank row
oDataSet.Tables[0].Rows.Add();


// Get a reference to the table
DataTable oTable = oDataSet.Tables[0];

// Get the number of rows
int iRowCount = oTable.Rows.Count - 1; 

// Get a reference to the new row
DataRow oRow = oTable.Rows[iRowCount];

// Edit the column values
oRow["CustomerName"] = "Someone Else";
oRow["CreditLimit"] = 15;

// Save the changes to the dataset
oDataSet.AcceptChanges();

// Create a command builder.
SqlCommandBuilder oBuilder = new SqlCommandBuilder(oDataAdapter);

// Update the changes to the backend
oDataAdapter.Update(oDataSet, oDataSet.Tables[0].TableName);