Arun is quite right. I cannot count the no. of times I have stressed this fact: Never call AcceptChanges before calling Update.
Trip down memory lane: --------------------------------- http://groups.google.co.in/group/DotNetDevelopment/browse_thread/thread/90c61f5f9eaa2959 http://groups.google.co.in/group/DotNetDevelopment/browse_thread/thread/1c8d34e74442dc7c http://groups.google.co.in/group/DotNetDevelopment/browse_thread/thread/8398c6b6c6f81d82 http://groups.google.co.in/group/DotNetDevelopment/browse_thread/thread/e4b3d7099721118f http://groups.google.co.in/group/DotNetDevelopment/browse_thread/thread/8ceb6c0a4d84389e On Feb 27, 10:52 am, ArunKumar <[email protected]> wrote: > Yes Now i am understand ur problem and ur solution 2 ur problem > why i am sending this > ie BeginEdit/EndEdit this is pushed to change the row state > > Now i am come to ur solution > Don't call acceptchanges method before Update > > My sugg > > what ever u can do with ur data table ie (new row > added,Modified,Deleted etc..) > then finaly call on single stmt > If Not DataTable.GetChanges Is Nothing Then adapter.Update > (DataTable.GetChanges) > DataTable.AcceptChanges() >
