dropdown list

Ruchi R

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 .

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hiren Soni16y ago
checkout this source code
0
Sam Hobbs16y ago
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.
0
Rekha Singh16y ago
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

0
Blocked Account17y ago
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.
0
Ruchi R17y ago
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 nCompanyName,nCompanyId 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";

}
0
Blocked Account17y ago
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!
0