Populate Dropdown on the basis of another in SSRS

Question

Hi All I have a dropdown with some values.I just wanted to populate another dropdown on the basis of the value selected from first dropdown. Could it be possible through SSRS? Can anyone help me out on this please!!! Thanks Prasant

Manoj Tandon · Answer

First Enable AutoPatsBack of DropDownList after that in Selected_index changed event of this DDL Write Code as Below protected void DropDownList1_ SelectedIndexChanged(object sender EventArgs e) { SqlDataAdapter da; DataSet ds = new DataSet(); try { da = new SqlDataAdapter(select book_Id book_name from book where category_name = ' + DropDownList1. SelectedItem.Text + ' your connection string); da.Fill(ds); DropDownList2.DataTextField = bokk_name; DropDownList2.DataValueField = book_Id; DropDownList2.DataSource = ds.Tables[0]; DropDownList2.DataBind(); } catch (Exception) { throw; } }