Datatable Updates and SQLCE

  • Thread starter Thread starter casy
  • Start date Start date
C

casy

Apologies for crossposting, but am lost..

Fairly new to .net
Running Orcas Beta 1 on Vista home
Sql Express and SQL Compact 3.5 installed

I have searched and searched and tried many times but I cannot get a
SQLCE datatable to work correctly even in VS 2005, I am using the
wizards,datagridview, the table has three columns including a primary
key,

No error is thrown, it just does nothing when the update button on the
navigator is pressed
The VB code calls validate,endedit and update. The 'haschanges' is
true.

Its got to be a basic problem as when I restart after stopping and
checking the DB, because the datgridview always shows the previously
edited data and not the underlying values in the uchanged db.

I really dont know where to look..

Simple project to test Datagridview Update
Using Orcas Designer Winforms
Using SqlExpress
- Make Connection to Northwind
- Add Data source (suppliers)
- Drag Data source on to form as Datagridview
- Run
Any edits to data are saved to database

Following the exact same steps using CE 3.5, the same update code (on
form) is generated but changes are not refected in DB,. There seems
to
be no refresh and the dataset also holds stale data.

Have tried creating a new 3.5 table but the same effect.


Stumped...
 
To any other first-timers, the solution from Ilya is below,

Ilya,

Thank you thank you!

You have hit the nail on the head, indeed I was looking at the
original database, a trap for the novice!

Kerry
 
Back
Top