Results 1 to 4 of 4

Thread: [RESOLVED] DataTable Schema

  1. #1

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    59

    Resolved [RESOLVED] DataTable Schema

    When I modify the table design within SQL is there an easy way to force VB to see the changes without rebuilding the database connections and datasets?

    Thanks,
    Boulent

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: DataTable Schema

    VB will see what you tell it to see.

    Your connection string won't change unless you change databases altogether.

    If you are referencing fields that no longer exist, or fields that are brand new, then in all likelyhood, you may need to revisit your VB code, depending on what you are doing in it.

  3. #3

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    59

    Re: DataTable Schema

    I am using connect to database to let my vb winforms app access a sql database.

    If I add a new column to a table, my app doesn't see the new column, is there an easy way to force it to do so.

  4. #4
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: DataTable Schema

    If you used the wizard to build the datasets I think you will need to go back though the wizard to update that dataset
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

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