get specific data from other database tables

Question

Hi!
   i have three tables in database province,division, and subdivision. i entered 4 provinces in province table using asp.net web page1. in next web page2 i used dropdown which get data from province table. for each province in dropdown i entered 6 divisions using textbox and save it in the division table. now in third web page3 i used two dropdowns one for province and one for division and a text box for subdivision entry.
i want that when i select a province from dropdown(e.g punjab) so the dropdown2 show me those divisions that i have entered for that particular province(e.g divsion1,divsion2 for punjab),not all the divisions of all the provinces. how is it possible?????please help me

Answer 1

Please find the attached. It is a complete solution for your question.


Kindly let me know, if you have any issues.

Answer 2

great sir very very great.it is 100% correct

Answer 3

excellent attachment Murali. saifullah go with murali, this is also one of the nice way.

Answer 4

You want the cascading dropdownlist .

http://www.asp.net/ajax/ajaxcontroltoolkit/samples/CascadingDropDown/CascadingDropDown.aspx
http://www.asp.net/ajax/ajaxcontroltoolkit/samples/walkthrough/ccdwithdb.aspx
http://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in-ASP.Net.aspx

Answer 5

Job1

for the very first dropdown (province) bind the all database record (you have 4 records). Code would be something like,

<asp:DropDownList
        id="DropDownList1"
        DataSourceID="SqlDataSource1"
        DataTextField="province"
        DataValueField="ID"
        Runat="server" AutoPostBack="True" />
</br>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
            ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
            SelectCommand="SELECT [ID], [province] FROM [tblprovince]"></asp:SqlDataSource>

Note: remember to mark autopostback enabled. 

Job2

Use the code in the code-behind for selectedIndexChenged event of above dropdown.

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
         //here you have to place the binding data of division drop down
         
    }


i hope this helps

Answer 6

sir i have two questions here.
1. should i bind both of the dropdowns to division table?
2. could you please tell me query?

Answer 7

You have to bind the dropdown control to your database. and execute some queries via dropdown change. 

Refer this post http://www.vbdotnetheaven.com/UploadFile/abhikumarvatsa/2333/