DB Update Problem??

Hot Topic

A way to swap variables?
Multiple Data Files (SQL Express) can be used in one application ?
unable to install visual c# 2005 express edition - mscrorsvw.exe - Unable To Locate DLL
making a default button
Icons
System Configuration Check Hangs
Font Problem
Starter Kit Trouble
Font Problem
Namespaces

VS Express Editions

Register for multiple users
Program flow - order of execution.
Autonumber field and Master with Detail Table Error ?
Switch between tabs using code???
Getpixel API
Game programming and VB 2005 express
Checking to see if a file is active on the internet?
where to get MicrosoftR Visual BasicR 2005 Express Edition: Build a Program Now!the registration benefits from
Accessing Oracle databases in Visual C# .Net Express
Visual Basic Express VS Visual Web Developer Express

DB Update Problem??

Hello everyone

I am somewhat new to VB, but not to programming in general.  When I am testing out code I have that updates local DB tables, everything appears to work well.  I close the app and reload and looks like changes are still there.  I then close VB Express and reopen and changes still appear to be there.  But the moment I try to view data in the table directly, I cannot see the values I would expect.  Afterwards, the values appear to be gone when running the application as well.  It's like any time I touch the DB in design, all changes I thought were made to the tables are completely gone!  Is this normal   Is there something I am possibly missing

Again, all this is being done through VB Express and not in a published application.

Any help would be appreciated!

Thanks

Answer this question

DB Update Problem??

  • Pramode

    I have a same problem, when clicking on save in BindingNavigator nothing happined, and when i close and reopen my app, my DB stay as it was before, and nothing change!

    I write this code on the event form_closing:

    Me.Validate()

    Me.AddressesBindingSource.EndEdit()

    Me.AddressesTableAdapter.Update(Me.FirstDatabaseDataSet.Addresses)

    but nothing happend and the DB didn't updated.

    Note: I'm dealing with access database

  • Oliver-LundK.de

    Why is coding the connection string with an absolute path such a problem Seems like the thing to do to me. Just save it as a file and ref that in your project. Then you can move the db file anywhere you want and just edit the connection file in notepad - instead of having to rebuild the whole project with a relative path to the new location. That seems to me an absolute must if you are going to creat client/server or n-tiered apps.

  • Amadeus

    Thank you very much MR HuyN_MS all the problem was in setting the LocalDataBase file property "Copy to Output" to "Copy if newer";;

    Thanks

  • Popsodav

    Hi,

    Looks like you're having troubles with Local Data File. Please take a look at this post with the answer. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=139410&SiteID=1.

    Best regards,



  • DB Update Problem??
Answer this question