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.

>Mike,
>
>Thank. I'm playing around with it but I can't seem to get it. Could you provide an example?
>
>
>>Kevin,
>>DataSets are disconnected from the source. The AcceptChanges() method does not have anything to do with the data source - it just notifies the DataSet to mark itself as current. You have to manually save the DataSet back to the source, and that involves a SQLCommand object configured with an Update SQL command (or Stored Proc).
>>
>>>Ok, what am I doing wring here. This compiles and runs, but the changes are not sent to SQL.
>>>DSCustomer is a typed dataset. The DataSet Visualize shows the new row.
>>>
>>>

>>>/*****************************************************
>>> * Get the customer dataset
>>>******************************************************/
>>>
>>>string sSelectCommand = "select * from Customers where CustomerKey = 1";
>>>
>>>SqlDataAdapter oDataAdapter = new SqlDataAdapter(sSelectCommand, oConnection);
>>>DSCustomer oDataSet = new DSCustomer();
>>>oDataAdapter.Fill(oDataSet, "DSCustomer");
>>>
>>>/*****************************************************
>>> * Or Create an empty customer dataset
>>>******************************************************/
>>>//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 last row
>>>DataRow oRow = oTable.Rows[iRowCount];
>>>
>>>// Edit the column values
>>>oRow["CustomerName"] = "Someone Else";
>>>oRow["CreditLimit"] = 15;
>>>
>>>// Save the changes
>>>oDataSet.AcceptChanges();
>>>