how to display selected data from dropdownlist in grid view in C# language

Question

hi frnds I have a dropdown listbox  in that I want to show different branches of college in that. when user selects one of the value from the drop-down listbox then the data corresponding to that branch( drop-down listbox) has to be displayed in the grid view C# language . for example : when user selects information technology from drop-down list box then list of faculty members related to information technology has to be displayed in grid view

Syed Shakeer · Answer

Hi conn.Open(); SqlCommand cmd=new SqlCommand(select branches from information_tech where branch_colmn_id=+dropDownlist1.SelectedValue+conn); SqlDataAdapter da=new SqlDataAdapter(cmd); DataSet ds=new DataSet(); da.Fill(dstablename); GridView1.DataSource=ds.Tables[tablename]; GridView1.DataBind();

Ankur Gupta · Answer

Syed method is correct. conn.Open(); SqlCommand cmd=new SqlCommand(select branches from information_tech where branch_colmn_id=+dropDownlist1.SelectedValue+conn); SqlDataAdapter da=new SqlDataAdapter(cmd); DataSet ds=new DataSet(); da.Fill(dstablename); GridView1.DataSource=ds.Tables[tablename]; GridView1.DataBind();

Hirendra Sisodiya · Answer

you can do according Syed.. thanks

Balamuruan B · Answer

in the selectedindex changed event of the drop down list u can read the selected value of the dropdown listby using that value u can query the data base and bind it to the result gridview.