ADO/ADO.NET - VS 2008 app unable to update sql server compact. Can connect and select. No errors.
Asked By David Simmons on 28-May-13 01:00 PM
Changed app to use SQL Server Compact database instead of SQL Server 2008 R2. Can connect and retrieve data into dataset but updates to rows don't work. return code is 0 from ExecuteNonQuery and no errors thrown. I have tried updating using the table adapter, ExecuteNonQuery using parameters and using a simple update statment. Any thoughts?