Cannot Update Database (2.0)
- From: "Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx>
- Date: Thu, 6 Sep 2007 13:04:05 -0600
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
.
- Prev by Date: Re: How migrate from SQL Express to SQL Server
- Next by Date: Re: original and proposed are different in datarow with date when same date!
- Previous by thread: Re: Database Mirroring Causes .NET Internal Network Provider Error 6
- Next by thread: Best connection management
- Index(es):
Relevant Pages
|
