sqldatasource selectparameters hooked to a control inside a gridview or formview?

J

jobs

Is there any way to do this?


<asp:SqlDataSource ID="DSCity1" runat="server" ConnectionString="<%
$ ConnectionStrings:pPLineaConnection%>"
ProviderName="System.Data.OracleClient"
SelectCommand="select City_Code, City from City where country_code=
&country">
<SelectParameters>
<asp:ControlParameter ControlID="CityDropDown1"
Name="country" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>


getting error:
Could not find control 'CityDropDown1' in ControlParameter 'country'.

Any way to do this? Thanks for any help or information!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,065
Latest member
OrderGreenAcreCBD

Latest Threads

Top