Need help understanding bindings - how do you link bound controls?

Question

0.00/5 (No votes)

See more:

I'm very inexperienced with regards to using databinding in VB.Net and am having a hard time resolving how to do what is probably really simple. I have a form with a combo box (used to select work order numbers) and a bunch of text boxes to display field information from the row associated with that work order number. My idea is to pull in the table into a dataset and then bind to the workorder table in that dataset. In the code below, I named my internal table "WorkOrders".

How do I get it so that you change the work order number in the combobox, that it will change the related data in the text boxes?

VB

Dim daAccess As OleDbDataAdapter
cnAccess.Open()
Dim SQL_RecentWorkOrders As String = "Select * from workorder where date>#" + dtToday.AddYears(-4).ToString + "# ORDER BY worknum DESC"
daAccess = New OleDbDataAdapter(SQL_RecentWorkOrders, cnAccess)
daAccess.Fill(dsAccess, "WorkOrders")
Dim dv As New DataView(dsAccess.Tables("WorkOrders"))
'Bind Work Orders
WorkOrderNumberCbo.DataBindings.Add("Text", dsAccess.Tables(0), "worknum")

WorkOrderNumberCbo.DataSource = dsAccess.Tables("WorkOrders").DefaultView
WorkOrderNumberCbo.DisplayMember = "worknum"
WorkOrderNumberCbo.ValueMember = "worknum"

CustIDTxt.DataBindings.Add("Text", dsAccess.Tables(0), "custid")
LastNameTxt.DataBindings.Add("Text", dsAccess.Tables(0), "operlast")
FirstNameTxt.DataBindings.Add("Text", dsAccess.Tables(0), "operfirst")
DescriptionTxt.DataBindings.Add("Text", dsAccess.Tables(0), "description")
AcresTxt.DataBindings.Add("Text", dsAccess.Tables(0), "acres")
GridSizeSelection.DataBindings.Add("Text", dsAccess.Tables(0), "grid")

Update: I figured out that I was handling the CurrencyManager wrong. After establishing a CurrencyManager object, I inserted the following line:

VB

cmWorkOrder = CType(Me.BindingContext(dsAccess.Tables(0)), CurrencyManager)

I then added this code:

VB

If IsNothing(cmWorkOrder) = False Then
    cmWorkOrder.Position = WorkOrderNumberCbo.SelectedIndex
    tmpText = WorkOrderNumberCbo.Text
End If

The problem I run into with this approach is that when I key in the value, while it does update the other fields correctly, it also has an annoying problem of moving the text for the most recently entered number to the top of the selection list, thereby hosing up all the relations based on position.

Can someone tell me how to disable this feature or at least how to change position in the CurrencyManager based on a primary key value instead?

Posted 1-Aug-11 8:39am

Tom Bihn

Updated 1-Aug-11 9:46am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tom Bihn · Answer 1 · 2011-08-02T02:30:00

I found the root cause of the issue with the list changing. Once I removed the explicit binding of the Combo Box to the same Data Source as used for the Display Member, my problem went away. I would like to make it update the fields as the Auto-Complete suggests items, but that doesn't happen until the user clicks away. I may be using the wrong event.