-Scott
***
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"
DefaultLoadingPanelID="RadAjaxLoadingPanel1">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadComboBox1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadComboBox1" />
<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
***
<telerik:RadComboBox ID="RadComboBox1" Runat="server"
DataSourceID="SqlDataSource1" DataTextField="CustBill"
DataValueField="CustBill" Height="122px" Skin="Windows7" Width="319px">
<Items>
<telerik:RadComboBoxItem Text="All" Value="0" Selected="true" />
</Items>
</telerik:RadComboBox>
*** This SQL Data Source populates the combo box ***
<
asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:crmDashboardConnectionString %>"
SelectCommand="SELECT TOP (10) CustBill FROM crmSalesSuperior WHERE (CustBill IN (SELECT CustBill FROM crmSalesSuperior AS crmSalesSuperior_1 WHERE (Branch = 102))) GROUP BY CustBill ORDER BY CustBill">
</asp:SqlDataSource>
*** This is the Grid's SQL data source, calling a stored procedure with a parameter from combo box. ***
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:crmDashboardConnectionString %>"
SelectCommand="CRMDashboardSales" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter Name="CustBill" ControlID="RadComboBox1"
PropertyName="SelectedValue" Type="String"
DefaultValue="Power Equipment Co " />
</SelectParameters>
</asp:SqlDataSource>