you have want like cascading drop down.
Programming With Sangani: Cascading Dropdownlist using webservices[
^]
or you want with out cascading
1st dropdown generate event selected index change and set autopostback ="true" like
<asp:dropdownlist id="dropcategory" runat="server" cssclass="styled span12" AutoPostBack="True" onprerender="dropcategory_PreRender" onselectedindexchanged="dropcategory_SelectedIndexChanged"> </asp:dropdownlist>
and Code Behind Selected Change event write below code. changes as per your requirment
if (dropcategory.SelectedIndex != 0)
{
DataTable objdt = new DataTable();
objdt = odal.selectbyquerydt("Select * from Sub_category_Master where cid ='" + Convert.ToInt32(dropcategory.SelectedValue) + "'");
dropsubcategory.DataSource = objdt;
dropsubcategory.DataValueField = "id";
dropsubcategory.DataTextField = "Subcategory";
dropsubcategory.DataBind();
dropsubcategory.Items.Insert(0, "----Select----");
}