Okay, I've found that a couple of samples apps (at least, Web apps) can
successfully update a database on my system. But I still cannot determine
why some will not.
I've prepared two tiny projects that will not update the database. I would
be very grateful if anyone is in a position to take a look at either or both
to see if they can tell me why.
WinDbTest (
http://www.softcircuits.com/WinDbTest.zip - 1.03MB)
==============================================
This is a very simple C# Windows application. I created a simple database
object and added several rows of data in Visual Studio.
I then added a new data source and selected the database created in the
previous step.
Next, I dragged the table from the Data Sources window and dropped it on my
form. This created a DataGridView control along with several data objects
(DataSet, BindingSource, TableAdapter, BindingNavigator).
Then I run the app and everything appears to work fine. I can navigate
through and create new records.
The problem is when I quite the application and restart it, all the changes
I made in the previous session are lost.
WebDbTest (
http://www.softcircuits.com/WebDbTest.zip - 247KB)
==============================================
This is an older sample Web application. I tried to create a new Web app for
this post but it actually worked! But this one does not and, although I've
compared the two extensively, I cannot figure out why the new one worked
when this one will not.
Again, everything appears to work. But when I make some changes and click
Update, my changes are lost.
Thanks for any tips!
Jonathan