Generate Update/delete for Dataadapter in code 1

[PoppapumpJ]

Hey,

I have built a dataadapter in a class that returns a dataset. Now I would like to use that same code to make my updates with. Is there a method that will generare my update/delete/add statments at run time, similar to the wizard. I do supply a select string.

thanks

 

[qwert231]

OleDbCommandBuilder

Example:

... ' Code that creates an Adapter named myAdapter
objBuilder = New OleDbCommandBuilder(myAdapter)
obj.Adapter.UpdateCommand = objBuilder.GetUpdateCommand()
obj.Adapter.InsertCommand = objBuilder.GetInsertCommand()
obj.Adapter.DeleteCommand = objBuilder.GetDeleteCommand()

Should do the trick for you.