Query Assistance - Binding Dropdown to values from OData Service

Posted on 2012-09-10
Medium Priority
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
  • 2

Expert Comment

by:Jean Marie Geeraerts
ID: 38386387

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

brendanlefavre earned 0 total points
ID: 38567858
The solution I used involved creating several parameters, and using a LINQ query.

Author Closing Comment

ID: 38941483
Answered my own question

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
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. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

862 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