INSERT,UPDATE on Attached SQL Database File not working.

Question

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.