How to fetch the data using drop-down list from the database

Hi sahil,
First On pageload event bind 1st dropdown then
 set AutoPostBack properties of DropDownList1 become true and on onselectedindexchanged just bind second dropdown.

IN ASPX page:

                           AutoPostBack="True"
                        onselectedindexchanged="DropDownList1_SelectedIndexChanged">
                   
                       >
                   


on cs page 

protected void Page_Load(object sender, EventArgs e)
    {

   if (!IsPostBack)
        {
  DropDownList1.DataSource = " your code";
     

        DropDownList1.DataBind();

}
}


 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
       
  DropDownList2.DataSource = " your code";
     

        DropDownList2.DataBind();
      
    }
I hope this will help you !!!!

Hi check this sequence you will get solution
In page load Bind first DropdownList
Page_Load
{
// Bind Dropdownlist1
}
Next Go to dropdownlist1 in Design view select it and hit F4 it will show property window here set AutoPostBack property to true close window now Double click on DropDownList1 it will generate SelectedIndexChangedEvent like
DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
//Now here fire your query to fill DropDownList2
}

Hi sahil, 
    your dropDown Problem solved or not here?

Hi Sahil,
I have not attached any file here, i have just given you suggestion for writing the code.

Hi SAhil,
On selectedindex changed event of dropdown1, you can wite the code to get data for dropdown2.
I hope this will work!!!!