Two Dropdown lists

DaMetroMan

Does anyone have a working eg in C# of one dropdown list being populated by the selection of the first. i.e. I need to populate the second dropdown with data related to what is chosen in the first one. Here's the code I use for the second dropdown: /**************************************************************************** String MyQuery = "SELECT DivisionDesc, DivisionNo FROM Divisions Where CompanyNo = " + (Int32.Parse(ddfirstList.SelectedItem.Value)-1); SqlDataAdapter MyCommand_Priot = new SqlDataAdapter(MyQuery, sqlConnection1); DataSet DS_Priot = new DataSet(); MyCommand_Priot.Fill(DS_Priot, "Divisions"); DataRowView ViewRow = DS_Priot.Tables["Divisions"].DefaultView[0]; ddSecondList.DataSource = DS_Priot.Tables["Divisions"].DefaultView; ddSecondList.DataTextField = "DivisionDesc"; ddSecondList.DataValueField = "DivisionNo"; ddSecondList.DataBind(); ****************************************************************************/ Every time I run it it comes back blank... Please show me what I'm overlooking. Thanks. Leon

3 Replies

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

DaMetroMan23y ago
Thanks guys I have it sorted!! The Answer I was looking for was: ************************************** String MyQuery = "SELECT DivisionDesc, DivisionNo FROM Divisions Where CompanyNo = " + (Int32.Parse(ddCompName.SelectedItem.Value)-1); SqlDataAdapter MyCommand_Priot = new SqlDataAdapter(MyQuery, sqlConnection1); DataSet DS_Priot = new DataSet(); MyCommand_Priot.Fill(DS_Priot, "Divisions"); ddCompDev.DataSource = DS_Priot.Tables[0]; ddCompDev.DataTextField = DS_Priot.Tables[0].Columns["DivisionDesc"].ColumnName.ToString(); ddCompDev.DataValueField = DS_Priot.Tables[0].Columns["DivisionNo"].ColumnName.ToString(); ddCompDev.DataBind(); **************************************
+1
thed0ct0r23y ago
I think this is correct: ... Where CompanyNo = " + ddfirstList.SelectedValue; or ...Where CompanyNo = " + Convert.ToInt32(ddfirstList.SelectedItem.Text); this if u need the text of the selected item
+1
jinwolf23y ago
Try: String MyQuery = "SELECT DivisionDesc, DivisionNo FROM Divisions Where CompanyNo = " + ddfirstList.Item[ddfirstList.SelectedItem].Value; I think you'll find it works better. Lee
+1