PC Review


Reply
Thread Tools Rate Thread

Cannot Update Database (2.0)

 
 
Jonathan Wood
Guest
Posts: n/a
 
      6th Sep 2007
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel Database via Access Main Database with a script Finnbar Microsoft Excel New Users 2 3rd Nov 2008 07:24 PM
Script to Update a Excel Database whenever a Access Database is mo Finnbar Microsoft Access 5 3rd Nov 2008 06:03 PM
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row rjr Microsoft Excel Programming 5 11th Jun 2006 09:43 PM
DATA UPDATE FROM CLIENT SIDE DATABASE TO WEB-SERVER DATABASE http://www.visual-basic-data-mining.net/forum Microsoft Access 0 23rd Sep 2004 03:35 PM
Executing UPDATE SQL command doesnot update the database immediately. Venu Koduru Microsoft Access 1 8th Sep 2003 09:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:53 PM.