dropdown list

Question

I have used two dropdown list one displays company name another displays department name.Now what i want to do is on selection of the company from dropdown list the second dropdownlist should display departments of that company only.I am doing it in C#.Can anyone plz hepl me out .

Hiren Soni · Answer

checkout this source code

Sam Hobbs · Answer

See Tutorial 8: Master/Detail Filtering With Two DropDownLists . It is part of a much larger tutorial but I hope that the one tutorial is useful for you. The entire set of tutorials ( 3-tier Architecture with ASP.NET 2.0 ) might be useful for showing how to design your application.

Rekha Singh · Answer

step 1.make autopostback property of firstdropdownlist as true. step 2.add items to firstdropdownlist in the page_load event step 3. on selectedindex_changed of firstdropdownlist add items to seconddropdownlist

Manish Dwivedi · Answer

Hi Make the AutoPostBack property to true of ddCustomer dropdownlist. and then check the value of the dataset u r getting back in the selectedindex changed event.

Ruchi R · Answer

hi thanks but its not working .i ll send u my coding .Please help me out protected void Page_Load( object sender EventArgs e) { LoadddCompany(); } protected void LoadddCompany() { string Myquery1 = select nCompanyNamenCompanyId from tblCompanyDetail  ; string Conn = ConfigurationSettings .AppSettings[ SqlConn ]; SqlConnection myconn = new SqlConnection (Conn); SqlDataAdapter ad = new SqlDataAdapter (Myquery1 myconn); DataSet ds = new DataSet (); ad.Fill(ds); ddCompany.DataSource = ds.Tables[0]; ddCompany.DataTextField = nCompanyName ; ddCompany.DataValueField = nCompanyId ; ddCompany.DataBind(); ddCompany.Items.Add( new ListItem ( None  0 )); ddCompany.SelectedValue = 0 ; } protected void ddCompany_SelectedIndexChanged( object sender EventArgs e) { string Myquery = select A.sDptName A.nDptID from tblDeptDetail A inner join tblCompanyDetail B on A.nCompanyId=B.nCompanyId ; if (ddCompany.SelectedValue != 0 ) { Myquery = Myquery +  and B.nCompanyId = ' + ddCompany.SelectedValue + ' ; } string Conn = ConfigurationSettings .AppSettings[ SqlConn ]; SqlConnection myconn = new SqlConnection (Conn); SqlDataAdapter ad = new SqlDataAdapter (Myquery myconn); DataSet ds = new DataSet (); ad.Fill(ds); ddDepartment.DataSource = ds.Tables[0]; ddDepartment.DataTextField = A.sDptName ; ddDepartment.DataValueField = A.nDptID ; ddDepartment.DataBind(); ddDepartment.Items.Add( new ListItem ( None  0 )); ddDepartment.SelectedValue = 0 ; }

Manish Dwivedi · Answer

Hi Anu On page load bind only the company dropdownlist and bind department dropdownlist in the selected index changed event of the company dropdownlist. your problem will be solved. Happy Coding!