I'm in desperate need of the code to Add New records (and modify records) to a Database using the DataSet and DataAdapter objects..

in my old .asp code, I could simply (for a new record) do a:

Recordset.AddNew
Recordset("Field1") = Value1
Recordset("Field2") = Value2
......
....
Recordset.Update


how do I do something similar to this in .aspx with dataset/dataadapters ?


thanks,