Databse Access Operations?

Question

I want to know there is a way to udapte(insertdelete) my Database ( SQL Server 2000) by using DataSet and SQLDataApdapter objects ?

tungqt · Answer

..myAdapter.Update(myDataSet).. I tried that way but the Database did not apply the changes. Is there some thing else need to write to my codes?

jcity444 · Answer

If you have made changes to your DataSet (such as adding a new row or updating an existing row in the Data Set) then you can call myAdapter.Update(myDataSet) and it will update and insert the changed rows for you using the sql commands in your data adapter's InsertCommand.CommandText and UpdateCommand.CommandText. -Mike G.