It feels as if the solution is on the tip of my fingers but i cant quite grasp it.

property, and executes the required INSERT, UPDATE, or DELETE statements iteratively for each row, based on the order of the indexes configured in the Data Set.

I think this is enough code to make sense of what I'm doing, but if more is needed just let me know and I can post it up as well.

For example, Update might execute a DELETE statement, followed by an INSERT statement, and then another DELETE statement, due to the ordering of the rows in the Data Table.

It should be noted that these statements are not performed as a batch process; each row is updated individually.

The Update method retrieves rows from the table listed in the first mapping before performing an update.

The Update then refreshes the row using the value of the property. After any data is loaded back into the Data Set, the On Row Updated event is raised, allowing the user to inspect the reconciled Data Set row and any output parameters returned by the command.

For more information, see Merging Data Set Contents and Handling Data Adapter Events.

The following examples demonstrate how to perform updates to modified rows by explicitly setting the Private Sub Adapter Update(By Val connection String As String) Using connection As Sql Connection = New Sql Connection( _ connection String) Dim adapter As Sql Data Adapter = New Sql Data Adapter( _ "SELECT Category ID, Category Name FROM dbo. Update Command = New Sql Command( _ "UPDATE Categories SET Category Name = @Category Name " & _ "WHERE Category ID = @Category ID", connection) adapter. Fill(category Table) Dim category Row As Data Row = category Table. Original Dim category Table As New Data Table adapter. encounters a change to a Data Row, it uses the Insert Command, Update Command, or Delete Command to process the change. Rows(0) category Row("Category Name") = "New Beverages" adapter. Write Line("Rows after update.") Dim row As Data Row For Each row In category Table. Write Line(": ", row(0), row(1)) Next End Using End Sub either by returning the auto-increment value as an output parameter of a stored procedure and mapping that to a column in a table, by returning the auto-increment value in the first row of a result set returned by a stored procedure or SQL statement, or by using the are sent to the data source is important. This allows you to maximize the performance of your ADO. For example, if a primary key value for an existing row is updated, and a new row has been added with the new primary key value as a foreign key, it is important to process the update before the insert. By specifying a subset of rows to be updated, you can control the order in which inserts, updates, and deletes are processed. As of now, the application runs perfectly and does exactly what I need it to, but the problem comes in when a large data set is reviewed.