Cor It needs only a form with a datagrid and this in the loadform event.

After that you have to delete the two ' , to show what I mean.

You see in this sample not the acceptchanges however when that is done with everything enabled the rows are as well presented in the way as what it in my opinion should be.

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.

So don't need to call explicitly Accept Changes because the Update method already does this.

However for me a kind of same behaviour, as you tell.

Sorry Cor Jay, This is one from the test I did, I also did it with Set Databinding (when you want that, it was even smaller, reply than) the result was almost the same however more difficult to explain.

Sorry Cor Hi ja Ypee, Whith that sample I show the behaviour that you tell. Data Source = dt 'with above endabled the datagrid shows 0 1 2 3 4 'Data Grid1.

(It has to do with the position of a row in a datagrid) With acceptchanges it is after an insert on the right place, while it is whithout that at the end. Data Source = Nothing 'now with these two rows disabled it displays 0 1 4 2 3 Dim dr As Data Row = dt.

RESOLUTION You have to explicitly add "SET NOCOUNT ON" in the trigger to prevent it from returning the "0 rows affected" message to the Sqloledb provider's cursor engine. It really requires very little time to post a comment but the pay off is well worth it when the Experts feel appreciated - see Tip One. perhaps and interesting article, also for you (but also didn't help me) Tell me a little bit more about the recordset and Table you are updating. Second are there more than one Table being effected by your batch update (with/without privary keys)?

The cursor engine interprets the "0 rows affected " to mean the delete failed. MORE INFORMATION Steps to Reproduce Behavior Task One: Create Test Table and Trigger For testing purposes, tables Table A and Table B will be created in the Pubs database with Table A being the parent table and Table B being the child table. Tip Five: Always post a response to every post that each Expert makes.

If the execution returns a failure code, the update is presumed to have failed. Re-create the trigger with "SET NOCOUNT ON" to avoid the error. Tip Three: Always post a comment when accepting a grade. Wsh2, I hope this information can help you along :-) ).. ASP Q193515 - PRB: Update of Same Record 2x w/Disconnect ADO Recordset Fails