Using dropdown to populate Gridview

[raghav m]

Hi,

Im new to silverlight , i m looking for a code snippet for populating the gridview using dropdown , using sql.

dropdown contains list of years and i want to display the information related to the particular year using sql .

if any one can post the code snippet or a link where i can learn and accomplish this task , would be more help ful.



thanks in advance.
raghav

[Vlad]

Hi,

I've made for you small example to illustrate you how to achieve this completely codeless using WCF RIA Services.

For my example I've used Northwind Customers / Orders with single additional method to the service:

public IQueryable<Order> GetOrdersByCustomerID(string customerID)
{
    return this.DataContext.Orders.Where(o=>o.CustomerID == customerID);
}

You can bind the combo to your first DomainDataSource to display Customers:

<riaControls:DomainDataSource x:Name="DomainDataSource1" AutoLoad="True" QueryName="GetCustomers">
    <riaControls:DomainDataSource.DomainContext>
        <web:NorthwindDomainContext />
    </riaControls:DomainDataSource.DomainContext>
</riaControls:DomainDataSource>

<telerikInput:RadComboBox x:Name="RadComboBox1" SelectedValuePath="CustomerID" DisplayMemberPath="CompanyName" ItemsSource="{Binding Data, ElementName=DomainDataSource1}" />

and bind the grid using second DomainDataSource to display selected Customer Orders:

<riaControls:DomainDataSource x:Name="DomainDataSource2" QueryName="GetOrdersByCustomerID">
    <riaControls:DomainDataSource.DomainContext>
        <web:NorthwindDomainContext />
    </riaControls:DomainDataSource.DomainContext>
    <riaControls:DomainDataSource.QueryParameters>
        <riaControls:ControlParameter ControlName="RadComboBox1" ParameterName="customerID" PropertyName="SelectedValue" RefreshEventName="SelectionChanged" />
    </riaControls:DomainDataSource.QueryParameters>
</riaControls:DomainDataSource>

<telerikGrid:RadGridView ItemsSource="{Binding Data, ElementName=DomainDataSource2}"  IsBusy="{Binding IsLoadingData, ElementName=DomainDataSource2}" />

The result:



You can check the attached application for reference.

Greetings,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[raghav m]

Thanks a ton Vlad,

Vlad