Adding rows to datatable.

[jcb1269]

Ok,

I'm having trouble here and not sure what I'm doing wrong. I'm looping through one table and updating rows in another table. When I do the following code:

dt.Rows.Add(dr)
dt.AcceptChanges()

When I view the records in the dt table, the new record is not there?!? Does AcceptChanges() not apply the data to the table?

Any help would be greatly appreciated, any links to help would be greatly appreciated.

Thank.

jb

[JBourgeois]

AcceptChanges does not save the data, it simply marks the DataTable as being synchronized with the data in the database, which in fact prevents any updating to the database table. Most examples you see in textbooks use AcceptChanges without reason, so many programmers tend to use it without knowing what it does.

What you are looking for is the Update method.

dt.Rows.Add(dr)
dt.Update