Binding + Database Linking - 500 pts

Posted on 2006-04-07
Last Modified: 2010-04-23
I have asked a similar question to this before, however this time I will provide the full scenario.

I have a contact table which has all the usual fields plus PhoneNumber and PhoneDescription 1 -5

These fields are bound to a form, the reason for keeping them all within the same table was to provide easier binding. It allows the user to change each phone description and number very easily. I choose five as this will be the maximum it will ever be.

The problem I have is that I am still wondering whether the contacts phone numbers should go in another table, the problem is that while it is the correct way to link it, it causes significant coding to get it working.

Ideas anyone
Question by:rocky050371
    LVL 6

    Accepted Solution

    I hope you are working with datatables.

    Say DataTable1 have your usual fields with a PKey
    Make another table DataTable2 with PKey, ContactPhone and ContactDescription.
    Create a DataSet (Dim ds as New System.Data.Dataset)
    '\\ Relate Parent Table(usual fields) with Phone Table as shown below

    and for data binding, use ds.Tables(0).DefaultView.
    Hope this will help you.

    Author Comment

    No I am not, the form is bound to the object.

    Author Comment

    It works like this

            Me.cboTitles.DataBindings.Add("Text", _currentcontact, "Title")
            Me.txtForename.DataBindings.Add("Text", _currentcontact, "FirstName")
            Me.txtSurname.DataBindings.Add("Text", _currentcontact, "LastName")
            Me.cboSalutation.DataBindings.Add("Text", _currentcontact, "Salutation")
            Me.cboDisplayAs.DataBindings.Add("Text", _currentcontact, "DisplayAs")
            Me.txtAddress1.DataBindings.Add("Text", _currentcontact, "Address1")
            Me.txtAddress2.DataBindings.Add("Text", _currentcontact, "Address2")
            Me.txtAddress3.DataBindings.Add("Text", _currentcontact, "Address3")
            Me.txtAddress4.DataBindings.Add("Text", _currentcontact, "Address4")
            Me.txtAddress5.DataBindings.Add("Text", _currentcontact, "Address5")
            Me.txtPostcode.DataBindings.Add("Text", _currentcontact, "Postcode")
            Me.btnPhone1.DataBindings.Add("Text", _currentcontact, "PhoneDescription1")
            Me.txtPhone1.DataBindings.Add("Text", _currentcontact, "PhoneNumber1")
            Me.btnPhone2.DataBindings.Add("Text", _currentcontact, "PhoneDescription2")
            Me.txtPhone2.DataBindings.Add("Text", _currentcontact, "PhoneNumber2")
            Me.btnPhone3.DataBindings.Add("Text", _currentcontact, "PhoneDescription3")
            Me.txtPhone3.DataBindings.Add("Text", _currentcontact, "PhoneNumber3")
            Me.btnPhone4.DataBindings.Add("Text", _currentcontact, "PhoneDescription4")
            Me.txtPhone4.DataBindings.Add("Text", _currentcontact, "PhoneNumber4")
            Me.btnPhone5.DataBindings.Add("Text", _currentcontact, "PhoneDescription5")
            Me.txtPhone5.DataBindings.Add("Text", _currentcontact, "PhoneNumber5")
            Me.txtEmail.DataBindings.Add("Text", _currentcontact, "Email")
            Me.chkPrimaryContact.DataBindings.Add("Checked", _currentcontact, "PrimaryContact")

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now