+ Reply to Thread
Results 1 to 4 of 4

Not able to see database updates until I re-buld the VB2010 project

  1. #1
    Registered User
    Join Date
    01-07-2016
    Location
    Delaware, USA
    MS-Off Ver
    2013
    Posts
    4

    Not able to see database updates until I re-buld the VB2010 project

    I realize the thread title is kind of cryptic...but here is what is happening.

    I hit F5 to run the program I am creating...and while it's running I have a form which I fill out and when I click the SAVE button the data successfully writes to a SQL database. I then continue on in the application and I can open another form which uses a DataGridView bound to that database table I just added a row to. However, I do not see the newly entered row...although I do see all the other rows that were previously in the table.

    Now if I end the application...then hit F5 again...I will see the data I just entered previous to stopping the application.

    Bottom line...I hit F5 to run the program and I am always one iteration behind in the DataGridView.

    I have not posted any code because everything that should be happening seems to working...except for the DGV not updating during Run time.

    Sorry if this is confusing...but I am confused about this myself...

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Not able to see database updates until I re-buld the VB2010 project

    You probably need a ActiveWorkbook.Connections(ConnectionName).Refresh on your form exit or as the last command after committing the data.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Not able to see database updates until I re-buld the VB2010 project

    is this a vba question or vb?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Not able to see database updates until I re-buld the VB2010 project

    I think you're in the wrong place mate, you're not going to get much .net help here

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 05-28-2013, 03:39 PM
  2. [SOLVED] Modify vba coding so that the database updates correctly
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2012, 02:31 AM
  3. Updates and Modification to Existing Project
    By Pherion in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-28-2009, 01:11 PM
  4. Database is very slow while opening Project
    By LilyMarie in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-26-2009, 03:22 AM
  5. Add Project to 'database'
    By jieyi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2009, 06:09 PM
  6. Replies: 0
    Last Post: 01-13-2009, 12:50 PM
  7. Making a project copy that auto updates?
    By KasperRye in forum Excel General
    Replies: 2
    Last Post: 02-06-2008, 08:55 AM
  8. Drawing driven database updates
    By Kennard in forum Excel General
    Replies: 1
    Last Post: 02-12-2006, 11:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1