CODEWITHSUNDEEP
c#.netsql-servertableadapter
anothershrubery
anothershrubery

Reputation: 21023

Loss of data after updating .Net TableAdapter

I had a program working with a database I created using SQL Server Compact Edition. Everything was updating and showing fine. Then I decided to change the Fill SQL statement to order by a field. After doing that I lost most of the data, with only 2 records remaining.

The 2 records were test records I added manually in SQL Server Management studio, before starting to build the program, and I thought I had deleted them. Anybody any ideas of what has happened?

Upvotes: 1

Views: 278

Answers (1)

Steve B
Steve B

Reputation: 37710

is your sdf file set as content file in VS ? if true, the previous run of your app had maybe worked with the bin{configuration}\yourdb.sdf file. For any reason (clean, rebuild, ...), the sdf file in your project may has been redeployed to the bin{configuration} folder...

Upvotes: 2

Related Questions