adapter.update() not working. need some exmples.

Question

adapter.update() giving error.. it is asking for parameters. means sqlcommandbuilder not generating insert command.

Santhosh N · Answer

you need to be have commandbuilder object along with the adapter inorder to work it correctly and also you need to have the dataset as parameter with the changes.. check here for the syntax and example on how to use this http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update.aspx