Re: I must be tarded.. please help

[David]

Something like:

Dim myUpdateCommand as New MySqlCommand()
Dim sqlUpdate as String

sqlUpdate = "UPDATE company SET .... "
myUpdateCommand.Connection = conn
myUpdateCommand.CommandText = sqlUpdate

myAdapter.UpdateCommand = myUpdateCommand

Then, after you modify your DataSet, when you call the .Update method, the DataAdapter will use this command object to process the update.
Use similar code for your Insert and Delete command objects, if necessary.

The DataAdapter merely processes the different command objects. You need to build the objects for it to process.

Alternatively, you can look into using the CommandBuilder. I've never used it, but it's supposed to automatically build the Insert, Update and Delete command objects based on the SelectCommand you've defined.