Query Assistance - Binding Dropdown to values from OData Service

Posted on 2012-09-10
Last Modified: 2013-03-01
I have a WCF Service running that is returning data from an Oracle database. There is currently only one table being returned in a read-only format with about 60 columns.

I have a LightSwitch 2012 application that is connected to the OData Data Source, and a grid view that displays all of the columns/data.

There is one query that is using a choice list to pass a parameter to the grid view, and filter data. This works with no problems. Now I'm trying to add a second query, and uses a column from the data source, and populate those values in a dropdown to all for further refining of the data within the grid.

I have added a parameter, but I am having trouble with configuring the query to create a dropdown.

I can pass in the value using a text box, and it returns the expected results.

SYP_PRO_DISTNO is the query that is currently working, SYP_PRO_ITEMNO is the column that I am trying to bind to a new dropdown menu

Question by:brendanlefavre
    LVL 8

    Expert Comment

    by:Jean Marie Geeraerts

    Unfortunately here I don't have the 2012 version yet, but I would expect that you need to check the binding of the parameter you added, so it is done in the same way as for the first parameter.
    Can you provide a screenshot/description of the bindings of both parameters on the screen?

    Accepted Solution

    The solution I used involved creating several parameters, and using a LINQ query.

    Author Closing Comment

    Answered my own question

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK ( for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
    Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    733 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

    24 Experts available now in Live!

    Get 1:1 Help Now