CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Updating Tables

  1. #1
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,284

    Updating Tables

    Hello, I've got an application that makes use of 2 Database tables and a seperate form for each. The problem is that:
    I want to update Table 1 out of form2(which is connected to table 2) and vice versa. What is the easiest way to do this¿
    Thanx

    F. T. W.

  2. #2
    Join Date
    Jan 2000
    Location
    Olen, Belgium
    Posts
    2,477

    Re: Updating Tables

    If you are using bound controls, it is simple. Just bound the controls to the other datasource. If you are using a datacontrol, you need to set the datacontrols datasource property to the other table. If you don't use a datacontrol, you must change this property for every control on the form.

    One thing you need to keep in mind is that this will only be possible if both tables have the same fields (or at least all the fields used on the forms)

    Tom Cannaerts
    [email protected]

    Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook
    Tom Cannaerts
    email: [email protected]
    www.tom.be (dutch site)

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

Featured