i'm using vb 2008 and local database sql server compact 3.5 to build a application.
the problem is that i can't insert a new data to the database from the app. i'm wrote the query right at dataset and using table adapter. but when i call the query, it succeed but the data don't exist at database.
for example:
at table adapter, i made AddData() like:
INSERT INTO supplier (kode_supp, name)
VALUES (@p1,@p2)
so at the app, i actually can call them by write: frmSupplier.tableadapter.AddData() but it's not working, do i miss something to connect the db? help me..