Combo box to grid view

Question

Hi... I am trying to retrieve value in a grid view that I was selected from a combo box. How can I do this anyone have a solution to solve this problem.

Vijay Yadav · Answer

Resolved?

Manoj Tandon · Answer

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); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } catch (Exception) { throw; }

Jiteendra Sampathirao · Answer

Hi set the autopostback=true propertyto the combo box... In the combo box event... store the combo box selected value in a variable.... write the select query like... select abcd from dat_table where some-thing=a; write some method to store the retrieved values in a DataSet.....and then to GridView Refer this link for More understanding(code available ) Link Hope it help....