VB.Net - SQL : Why wont data save during development but will after being published and installed?

Question

Why is it that when working on a Visual Basic application with SQL in Visual Studio 2008 I can't update/save changes when working on the database but after publish and install the code works fine???

Kirtan Patel · Answer

Friend Its Because when you Insert Data in Visual Studio Debug Mode Visual Studio Creates Copy of Your Actual Database into Debug Folder and Data you insert Goes in that Copy of Your Database File . this is Done by visual Studio Because Visual Studio not want to Spoil Actual Database when you test your Application .

Sam Hobbs · Answer

It is an option that you can change when the project is created. When a project is created you are asked if you want to create a copy of the data. The default is yes but I always say no. Perhaps Kirtan can tell you how to change the project that you already have.