There is no error, the dataset is getting updated, but the database is not updated.
I am using Windows authentication in connection string to the database. I have given accept changes on update.
Sql-server – I cannot write into SQL Server 2008 R2 express edition from C#
sql-server-2008-r2
Related Question
- Sql-server – SQL SERVER installation error for any version 2008 r2 express edition
- Sql-server – SQL Server Express in a shared hosting environment
- Sql-server – SQL Server connection failed for domain user from Mac OS machine
- Sql-server – Cannot Connect Using SSMS to Local SQL Server 2008 R2
- SQL Server Connection Error – Unable to Connect After Upgrading
- Sql-server – Cannot log in to SQL Server 2008 R2
- SQL Server – Invalid Connection Error on SQL Server 2008
- Sql-server – Overlapped I/O error installing SQL Server 2008 R2 SP2 Express
Best Answer
Are you using the
User InstancesandAttachDbFileNameoptions in your connection string? If so I will bet that you are actually connected to two different copies of your database. You need to make sure you are connecting to the same copy - I would suggest manually attaching the database on your Express instance, and always connecting to that without the use ofUser InstancesandAttachDbFileName.If this is not the case, please show the connection string you are using in C# and how you are validating that the data is not updated (e.g. you are probably using a different application and/or connection string for that).
The
User Instancesfeature is actually deprecated for future development work. In SQL Server 2012 this is replaced with SqlLocalDb.