how to create sqldatasource for dropdownlist into gridview

Question

Hi Guys Please help me I have to Dropdownlist put into FooterTemplate in Gridview how to make sqldatasource is working as dropdownlist as control ID in webform very easy but i did not know into internal girdview. the photo support the problem : see to the last 2 dropdownlist . DropDownlist5 is Region and DropDownlist is City in order to filter cities according to regions .

Abdalla Elawad · Answer

Hi Shakti Singh Dulawat My Problem was solved . i put sqldatasource into footer Template Now it Working Good DataSourceID=SqlDataSource3 DataTextField=City DataValueField=City Width=90 Font-Size=Small Font-Names=Calibri> Selected City ConnectionString=  SelectCommand=SELECT City FROM RegionCity2 WHERE (Region = @Region)> PropertyName=SelectedValue Type=String /> ControlToValidate=dd_City Text=*Required ForeColor=Red>

Shakti Singh Dulawat · Answer

abbreviation ID= ddState runat= server DataSourceID= ddstates DataTextField= StateName > ddstates runat= server ConnectionString=   SelectCommand= select StateName abbreviation from state order by abbreviation >