Question Database Not getting Updated

[nick.laddha]

I added a Service Database in the base folder using add new Item in VB.
Then used the connection string given by the wizard of adding the database.

Then used Execute non query to insert a record into a table in the database but it doesnt update the table and there are no errors and exceptions while running the query. It simply doesnt update.

I tried querying the database from the server explorer query builder, it works but now through code.

Any help would be highly appreciated .

Thanks.

 

[jmcilhinney]

Most likely it does update. By default, the database in your output folder is overwritten with a new copy each time you build. Follow the first link in my signature for more information.

 

[cjard]

A similar discussion to the microsoft link here can be found in the DNU link in my signature