Updating dataset in vb net
Ole Db Data Adapter Dim sql As String Private Sub Add Record_Load(By Val sender As System.
Accept Changes() Begin Edit() End Edit() I try to use them like this, to change the value of a field in first row: ds. I also wanted it so I could make a new record by filling out the form, and hitting the new button. I want it so it can delete the selected / presented record (namely basing it off the id field, such as 1 or 2). OLEDB.4.0;" db Source = "Data Source = C:\Documents and Settings\Eric\My Documents\Visual Studio 2010\Projects\EGI Movie Catalog\EGI Movie Catalog\db1.mdb" con. when calling this code it takes many seconds to update the database Sql Data Adapter1. Accept Changes() i'm also wondering because w/ out Accept Changes the data is still save into the database and it is now faster. The values in the Data Row are moved to the parameter values.2. If there are output parameters, they are placed in the Data Row.7. Ernest "ja YPee" does anyone experienced slowness when updating a dataset using Accept Changes? Ernest "ja YPee" does anyone experienced slowness when updating a dataset using Accept Changes? however i have this scenario that if i don't use Accept Changes the record in the datagrid (which contains related table) is not showing this is the scenario: i have a parent/child form that after clicking a checkbox in the parent form the program will execute the stored procedure from sql server 2000 then save the data in the related table that is based on the criteria from the primary table and filling the datagrid (which contains related table) but i can't see the changes after clicking the checkbox if i don't use Accept Changes after an update. On Fri, 0200, "Ernest Morariu" From MSDN: When using Update, the order of execution is as follows:1. If the command is set to First Returned Record, then the first returnedresult is placed in the Data Row.6. So don't need to call explicitly Accept Changes because the Update methodalready does this.