Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Data are correctly saved, but where? NOT in .sdf!

Author  Topic 

marsala.marco
Starting Member

1 Post

Posted - 2009-11-24 : 16:50:37
Hi.

Brief details about the app: MS VS 2008, SQL Server CE 3.5 (.sdf file), DataGridView (saving all data on exit using TableAdapter.Update(DataSet)).

Brief description of the problem: even if my app correctly save all required data, the .sdf file, opened with VS, apparently doesn't contain these data.
I know that data are correctly saved because if, I save a data through my app, then I restart the computer and re-open the app, all data I saved are correctly shown as they should be. So data are saved in some place, but not in the .sdf file.

The question are:
1) where are the data?
2) how to force the app to save the data where they should be, that is, into the .sdf file?

I can provide the complete VS solution if needed.

Best Regards.

--Dr. Marco Marsala
   

- Advertisement -