I've two Drop Down List Box in a form and need to change the 2nd dropdown lists

[rajendradhakal]

I've two Drop Down List Box in a form and need to change the 2nd dropdown lists value on selection of 1st dropdownlist. I've following code

<asp:AccessDataSource ID="AccessDataSource1" runat="server" 
        DataFile="c:\dbase.mdb" 
        SelectCommand="SELECT [CcompCode], [compname] FROM [mymain]">
    </asp:AccessDataSource>
    Company Name<asp:DropDownList ID="DropDownList1" runat="server" 
        DataSourceID="AccessDataSource1" DataTextField="compname" 
        DataValueField="CcompCode" 
        onselectedindexchanged="DropDownList1_SelectedIndexChanged">
    </asp:DropDownList>
    <br />
    Financial Year<asp:DropDownList ID="DropDownList2" runat="server" 
        DataSourceID="AccessDataSource2" DataTextField="Fiscalyear" 
        DataValueField="fiscalid">
    </asp:DropDownList>
    
    <asp:AccessDataSource ID="AccessDataSource2" runat="server" 
        DataFile="c:\dbase.mdb" >
    </asp:AccessDataSource>

the 2nd dropdownlist should selection based on company code, it means dropdownlists data value
How to do it Help needed

Check out this: http://www.dotnetcurry.com/ShowArticle.aspx?ID=221

and this: http://www.asp.net/ajax/ajaxcontroltoolkit/samples/CascadingDropDown/CascadingDropDown.aspx

[rajendradhakal]

Actually i'm fully new to this one. I've done vb6 since long ago. From where to donwload and

Check out this: http://www.dotnetcurry.com/ShowArticle.aspx?ID=221

and this: http://www.asp.net/ajax/ajaxcontroltoolkit/samples/CascadingDropDown/CascadingDropDown.aspx

[rajendradhakal]

http://www.asp.net/ajax/ajaxcontroltoolkit/samples/CascadingDropDown/CascadingDropDown.aspx

yea this is best way but unable to implement due to few ideas.