Issues updating data table in an SQLExpress database via stored procedures from my windows application

jepaske

I have created a local database (SQLExpress) within my windows application. I created stored procedures to ease the data processing. I can connect and I can extract data from the data tables into my application with no problem. However I can't perform any data updates from within my program. I can run the stored procesures from the data interface and they work without issue. I run them from my program and they tell me that rows have been updated, but when I go and open the tables (from server explorer) to review the updates, they are not there. I can't get it to generate any error messages so I can't debug...

Has any one else seen this situation... it is set for Intergrated Security = true, User Instance = true...

Thanks for any help...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

jepaske18y ago
Actually found the error... I didn't realize that the sqlexpress database was copied to the bin directory and all changes were actually being made there. As the configuration for the parent database was set to copy always, any data changes made to the db in the bin directory were overwritten the next time the app was started... Now if I can figure out how to get the parent db updated to the changes made in the child...

Thanks for the reply.
Kapil Deo Malhotra18y ago
Can you share your code so we can look if there is any thing not working as expected? I assume you have the stored procedure which takes the parameter and having Update statement which updates the record with specific condition.

How are you passing the parameters after calling the stored procedure?