I need to make my DropDownList2 dependent on my DropDownList1.
DDL1 gets it's dropdown choices from a table "SegmentsPrimary".
It has "seg_id" with data like 1,2,3,4 and "seg_name" like Paper, Film, Etc...
DDL2 gets it's dropdown choices from a table "SegmentsSecondary".
It has "seg_id" with data like 1,2,3,4 and "parent_seg"_id like 1,2,3,4 and "seg_name" like Paper, Film, Etc...
So I need DDL2 to do kind of like this...
SelectCommand="SELECT [seg_id], [parent_seg_id], [seg_name] FROM [SegmentsSecondary] WHERE ([parent_seg_id] = @parent_seg_id)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="parent_seg_id" PropertyName="SelectedValue" Type=< ...
Go to the complete details ...