retreiving the values from 1dropdownlist to another in 3tier architecture

Hi

First you set the datasource of ddlCountry dropdown and set the binding,
Then onselectedindexchanged event of ddlCountry, take the selected country and retrive the list of states for that Country and assign to ddlState and databind the dropdownlist. Same way you can populate the city drop down on selection of State.

Thanks,
Debata

Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator

ResponseDTO objResponseDTO = (ResponseDTO)new TP.Services().Execute(TVCConstants.GetCitationStages);
ddlstage.DataSource = objResponseDTO.ReturnObject;
ddlstage.DataTextField = "Country";
ddlstage.DataValueField = "Country";
ddlstage.DataBind();
//dropdown selectedchangedevent of country
Country= ddlcountry.SelectedValue;
ResponseDTO objResponseDTO = (ResponseDTO)new TP.Services().ExecuteResponse(Country,TVCConstants.GetCitationStatuses);
ddlstatus.DataSource = objResponseDTO.ReturnObject;
ddlstatus.DataTextField = "state";
ddlstatus.DataValueField = "state";
ddlstatus.DataBind();
ddlstatus.Items.Insert(0, new ListItem("--Select--", "0"));
//drop selected event of state
State= ddlstate.SelectedValue;
ResponseDTO objResponseDTO = (ResponseDTO)newTP.Services().ExecuteResponse(stage,TVCConstants.GetCitationtypes);
ddltype.DataSource = objResponseDTO.ReturnObject;
ddltype.DataTextField = "cities";
ddltype.DataValueField = "cities";
ddltype.DataBind();
ddltype.Items.Insert(0, new ListItem("--Select--", "0"));

if countries,states,cities in ur database this work

Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator