0
Please find the attached. It is a complete solution for your question.
Kindly let me know, if you have any issues.
Accepted 0
great sir very very great.it is 100% correct
0
excellent attachment Murali. saifullah go with murali, this is also one of the nice way.
0
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
0
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
0
sir i have two questions here.
1. should i bind both of the dropdowns to division table?
2. could you please tell me query?
0