Eric

Eric

  • NA
  • 8
  • 0

Database tables not reflecting changes made during run-time

Mar 17 2008 10:01 PM
Hello.  I am currently working on a project that makes several insert, update, and delete queries on a database.  Everything works fine while the program is running.  For example, after an insert, a Select * query shows that that row was successfully added.  However, when I exit the program and return to the database explorer in Visual C# and click "Show Table Data", the item I just added during program execution is not in the table.  I have tried doing adaptermanager.Update() and dataset.AcceptChanges() calls as well as using SqlCommand queries directly and none seem to be inserting the data into the actual database on the hard drive.  Can you please tell me what I am doing wrong or what I should try instead?  The database I am using is a Service-based Database added as a new item from the solution explorer window in Visual C# Express 2008, and is stored in the same folder as the project solution.  Please let me know if you need anymore information that will clarify my problem.  Thank you and I look forward to your reply.

Answers (6)