Results 1 to 2 of 2

Thread: [Solved] One table not updated using VB 2010 Express and SQL Server 2008 Express DB

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2010
    Location
    Lake Gaston, NC
    Posts
    453

    [Solved] One table not updated using VB 2010 Express and SQL Server 2008 Express DB

    I have a Managers table and a Dealership table in my SQL Server 2008 Express Database. (I'm new to SQL Server)

    I am using the code below to update the dataset. Changes to the Dealership table are not being reflected in the dataset. They show immediately after the update, but if I close the project and reopen the project, the changes are missing. Changes to the Manager file are reflected just fine.

    I just noticed that my TableAdapterManager says "ManagersTableTableAdapter" in properties and there is no TableAdapterManager for the DealershipTable.
    Is this OK or not?

    What could cause this??

    undefined Code:
    1. Me.Validate()
    2.     Me.DealershipTableBindingSource.EndEdit()
    3.     Me.ManagersTableBindingSource.EndEdit()
    4.     Me.TableAdapterManager.UpdateAll(Me.DeiServerDBsDataSet)
    Last edited by DexterRose; May 7th, 2013 at 10:39 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width