SQL 2005 SP1 - tableadapter.update with ado.net  
Author Message
schmidt787





PostPosted: .NET Framework Data Access and Storage, SQL 2005 SP1 - tableadapter.update with ado.net Top

I fill a dataset with tableadapter.fill. Then I change some data with a datagrid. After that I use tableadapter.update -> I got the number of rows changed with the transaction, but the data won't be updated :(

So what can be the problem With Access it works and with Vista as host too! Only my XP SP2 with Visual Studio 2005 and SQL Developer Edition 2005 SP1 makes that problem...

I hope you habe a suggestion for me! Thank you, Florian



.NET Development3  
 
 
Bill Lin - MSFT





PostPosted: .NET Framework Data Access and Storage, SQL 2005 SP1 - tableadapter.update with ado.net Top

Hope you've read the sticky FAQ post before asking the question. The most common mistake is to call AcceptChanges() beforehand. Also make sure you've completed the transaction.