Getting error passing combo box value as parameter to stored procedure

[Scott]

I am trying to filter a grid's data based on values selected in a combo box.  The combo box values are databound to a table and the grid is using a SQL Server stored procedure.  When I try to run the code I receive the following error:

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or Function 'CRMDashboardSales' expects parameter '@CustBill', which was not supplied.

Why does SQL Server get this error when my SelectParameter is defined? 

Code for the grid's datasource:
<asp:SqlDataSource ID="gridsource2" runat="server"

    ConnectionString="<%$ ConnectionStrings:crmDashboardConnectionString %>"      ProviderName="<%$ ConnectionStrings:crmDashboardConnectionString.ProviderName %>"

 

 

 

     SelectCommand="CRMDashboardSales" SelectCommandType="StoredProcedure">

 

 

    <SelectParameters>

 

        <asp:ControlParameter ControlID="NamesDDL" Name="CustBill"

 

 

        PropertyName="SelectedValue" Type="String" />

 

    </SelectParameters>

 

</asp:SqlDataSource>

 

The combo box data value contains CustBill column and is specified as the parameter to send to the stored procedure.  I've also included the Ajax Manager code below for reference.  Thx.

<

telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"     
DefaultLoadingPanelID="RadAjaxLoadingPanel1"> 
    <AjaxSettings>

 

 

    <telerik:AjaxSetting AjaxControlID="NamesDDL"> 
        <UpdatedControls> 
            <telerik:AjaxUpdatedControl ControlID="OrdersGrid" LoadingPanelID="AjaxLoadingPanel1" />

 

 

            <telerik:AjaxUpdatedControl ControlID="NamesDDL" />

 

 

        </UpdatedControls>  

    </telerik:AjaxSetting> 
    </AjaxSettings>
</telerik:RadAjaxManager>

 

 

 

 

 

 

 

 

[Simon]

Hello Scott,

Could you also paste here the definition of the RadComboBox and any code that is manipulating it on the server and the client?

Regards,
Simon
the Telerik team

[Scott]

I found the solution to this error.  Was using an ODBC connection instead of a direct SQL Server connection. Once I removed the ODBC and added the new SQL Server connection, I am able to pass parameters without error.  Thanks for your quick follow-up.
-Scott