using SQL - nothing has changed

[hemza]

Hi, I have been programming for years but always using basic stuff because that's all what I needed. Now, I am trying to use SQL and it is really giving me a hard time.

Info: I use VB.NET 2008 Express edition
I have SQL Server 2008 Express edition AND Microsoft SQL Server Compact 3.5

Let's say I have a project in VB.NET and I have a database db.sdf with table Tbl inside of it. Tbl has two columns "number" and "job" as follows

number job
1 carpenter
2 student

My goal is to put some code to remove a row/insert a row/update a row. All the codes I tried from Internet do the required job at run time on the dataset but whenever I stop the program and go back to my databases, nothing has changed.

Can someone reply while attaching a simple example project with the above database (.sdf) where he inserts/updates/deletes rows with the background database being affected (i.e. when I stop the program, the database will contain the modified info).

I am almost pulling my hair off with this.

Thank you so much.

 

[jmcilhinney]

Read this:

How to: Manage Local Data Files in Your Project

 

[hemza]

THANK YOU SO VERY MUCH It works!!!!!

I thought everyone was modifying their source database, that's why I kept trying new codes every time.

 

[cjard]

It works!!!!!

Did you doubt it?

I thought everyone was modifying their source database, that's why I kept trying new codes every time.

It's a very common problem.. you're not alone