Data is not getting updated in dropdownlist using data set.

[Parita Pandya]

Data is not getting updated in dropdownlist using data set:

 protected void SpecificationNameDropDownList_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (SpecificationNameDropDownList.SelectedItem.Text != null)
            {
                SpecificationValueLabel.Visible = true;
                SpecificationValueDropDownList.Visible = true;
                SqlConnection sqlConnection = new SqlConnection(this.connectionString);
                int specificationcode = Convert.ToInt32(SpecificationNameDropDownList.SelectedValue);
                DataSet specificationNameDS = new DataSet();
                string getSpecificationValue = "SELECT S.SpecificationValueCode,S.SpecificationValue FROM SpecificationValueMaster S,SpecificationMaster SV WHERE SV.SpecificationCode='" + specificationcode + "' AND SV.SpecificationCode = S.SpecificationCode";
                SqlDataAdapter SpecificationValueSDA = new SqlDataAdapter(getSpecificationValue, sqlConnection);
                SpecificationValueSDA.Fill(specificationNameDS, "SpecificationValueMaster");
                SpecificationValueDropDownList.DataSource = specificationNameDS;
                SpecificationValueDropDownList.DataTextField = "SpecificationValue";
                SpecificationValueDropDownList.DataValueField = "SpecificationValueCode";
                SpecificationValueDropDownList.DataBind();
                SpecificationValueDropDownList.Items.Insert(0, new ListItem("Select Value", ""));
            }
            else
            {
                SpecificationValueLabel.Visible = false;
                SpecificationValueDropDownList.Visible = false;
            }
        }

[Frinavale]

You are populating the DropDownList in the following case:

if (SpecificationNameDropDownList.DataSource != null)

Are you sure that is the case that you want?

Would it make more sense to populate the list in the following case instead?

if (SpecificationNameDropDownList.SelectedItem.Text == null)

Or how about this case:

if (SpecificationNameDropDownList.DataSource == null)

-Frinny