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???