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

Muralidharan Deenathayalan · Answer

Please find the attached. It is a complete solution for your question. Kindly let me know if you have any issues.

saifullah khan · Answer

great sir very very great.it is 100% correct

Abhimanyu K Vatsa · Answer

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

Muralidharan Deenathayalan · Answer

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

Abhimanyu K Vatsa · Answer

Job1 for the very first dropdown (province) bind the all database record (you have 4 records). Code would be something like id=DropDownList1 DataSourceID=SqlDataSource1 DataTextField=province DataValueField=ID Runat=server AutoPostBack=True />  ProviderName=  SelectCommand=SELECT [ID] [province] FROM [tblprovince]> 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

saifullah khan · Answer

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

Abhimanyu K Vatsa · Answer

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/