Is a 3 nested dropdpwnlist achievable?

Is a 3 nested dropdpwnlist achievable?

am 07.04.2008 10:46:06 von naijacoder

I have a 3 dropdownlist and a gridview to display..
What i want is if i load the page i want all the dropdownlist and the
Gridview to get populated and linked on the fly.

But my problem now is when i load the page i want all the dropdownlist
should be populated and linked automatically.
but it doesn't .The first 2 works the last dropdownlist is empty and the
gridview shows nothing..
Any ideas what 'm doing wrong?

All the 3 dropdownlist are linked like so below


































Select a Dealer

DataSourceID="SqlDataSource4"

DataTextField="dealer" DataValueField="dealer">






SelectCommand="spGetDealer"
SelectCommandType="StoredProcedure">


Select a Master Code

DataSourceID="SqlDataSource1" DataTextField="Master_Code"

DataValueField="mc_id"
OnSelectedIndexChanged="ddlMaster_SelectedIndexChanged"

AutoPostBack="true">





SelectCommand="[spGetAllScheduleMaster]"
SelectCommandType="StoredProcedure">



PropertyName="SelectedValue"

Type="string" />


Select a Plan Value

DataSourceID="SqlDataSource2"

DataTextField="Plan Code" DataValueField="plan_id"
OnDataBound="ddlPlans_DataBound">





SelectCommand="spGetPlanValuesByID" SelectCommandType="StoredProcedure">



PropertyName="SelectedValue"

Type="Int32" />