Loading

Databse Access Operations?

tungqt

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

tungqt21y ago
..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?
jcity44421y ago
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.