The attached sample solution demonstrates an implementation of the scenario on you side. It uses Telerik Data Access in the data access layer and Telerik UI for ASP.NET AJAX controls in the user interface. As an approach for the management of the Data Access context, the sample utilizes the pattern described in this article
. The actual filtering of the data is performed in the method that handles the OnClick event of the button on the page. A key moment in the implementation is that the result is enumerated (the ToList() call) before it is passed as a datasource for the dropdown box.
The sample is based on the NorthwindOA sample database that is distributed with Telerik Data Access Samples Kit
, and can be started with the help of the following steps:
1. Unzip the project.
2. Edit the connection string in the Web.config file of the web application
, to provide the name of the server on your side.
3. On the server, create the NorthwindOA
sample database (you can take it from the install folder of Samples Kit once it is installed on the machine).
4. Open the solution in Visual Studio and upgrade the references as described here
5. Run the application for a test.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map