0

Hi Friends,

I am facing a very bad problem.I have added an SQL Database using VS 2005>>Add New Item>>Sql Database.The problem I am facing is not able to execute an INSERT or UPDATE.But the thing is that just after inserting and viewing the contents of the same table in the same event,the inserted record is displaying.But if I close the application and look into table manually I couldn't see the newly entered record.

ExecuteNonQuery() is working and no exception is thrown.Please Help.Seems like some weird is happening:( .I dont have an SQL Server installed.I am using VS 2005 only to develop a database application.

Thanks in advance.

3
Contributors
2
Replies
4
Views
9 Years
Discussion Span
Last Post by DdoubleD
0

I am facing the same problem :(
The SQL INSERT statement works just fine, but the inserted rows get deleted after closing the application! I only have this problem when using an attached database.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.