VB.NET Cannot Bind This Event : Column does not belong to table

I am receiving a VB.NET run time error as stated in the title.  I changed a text field to a drop-down as follows in bold, specifically the line next to the arrows.

                    Dim LI As ListItem
                    If DR("Employee_Cd").ToString.Length > 0 Then

-->>>>>>          LI = New ListItem(DR("Employee_Nm"), DR("Employee_Cd"))
                        If Not Me.ddlEmployeeName.Items.Contains(LI) Then
                            Me.ddlEmployeeName.Items.Add(LI)
                        End If
                    End If
                    ddlEmployeeName.SelectedValue = DR("Employee_Cd")


                  "This code follows the above and is working correctly"

                    If DR("Supervisor_Cd").ToString.Length > 0 Then

                        LI = New ListItem(DR("Supervisor_Nm"), DR("Supervisor_Cd"))
                        If Not Me.ddlSupervisor.Items.Contains(LI) Then
                            Me.ddlSupervisor.Items.Add(LI)
                        End If
                    End If
                    ddlSupervisor.SelectedValue = DR("Supervisor_Cd")
66chawgerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ronald BusterOwnerCommented:
Looks likes the field "Employee_Nm" is not in the table or queryresult you are querying.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
66chawgerAuthor Commented:
That's what I don't understand...if you look at the code right below it, i.e, supervisor_nm, is not explicitly defined in the queryresult either.
66chawgerAuthor Commented:
Ron,

I am just overthinking.... you are correct!   The data event that is saved is returned in a separate query result via a different stored procedure.   I just needed to take the blinders off.  Thanks!
66chawgerAuthor Commented:
Expert stated the obvious... which in this case is what I needed to be looking at.   Never afraid to ask a question and always glad when someone replies in kind.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.