Member Avatar for joshymraj

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
  • 98 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by DdoubleD

Recommended Answers

All 2 Replies

Member Avatar for BadAssMF

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.