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

Question

In my from I hae one drop-down box. If I will select one entry from the drop-down then in another drop-down the data will be retrive automatically on basis of the selected value of previous drop-down box. How is it possible? Somewhat I have idea is I have to pass one query to fetch the data from the database. but where should I have to write that query and how is it possible?
Please let me know.

Soft Corner · Answer

ok sahil  check this rar Krishna already given you the solution .. let me give you complete code of example..

Sahil Jani · Answer

Thank you so much to all. I got my solution with the help of you all people. Thanks again.

Suthish Nair · Answer

If the query got resolved then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.

chiranjita nayak · Answer

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 !!!!

Krishna Garad · Answer

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 }

Sahil Jani · Answer

Hi Shrikant Actually I dont know how to fire query? Means how will I get output what I want? Just give me idea that where I have to fire the query? Then I will try my self to write the code.

Soft Corner · Answer

Hi sahil your dropDown Problem solved or not here?

Vijay Yadav · Answer

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

Sahil Jani · Answer

I didn't get any attached file or code written below your text.

Vijay Yadav · Answer

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