ASP.Net DropDownList SelectedIndexChanged event not firing

rasika

SOLVED CLOSED ACTIVE ANSWERED
User: rasika
Posted: on Jun 06, 2013 12:05 AM
Forum: Data Controls
Answer: 2
Views: 17179

hello sir,

i take drop down list control ,from below code i bind data into drop down list from database...

 public void load()
    {
        try
        {
            string sCon = gv.constr;
            MySqlConnection con = new MySqlConnection(sCon);
            con.Open();
            String s = "Select * from company";
            MySqlCommand cmd = new MySqlCommand(s, con);
            //DataTable dt = new DataTable();
            DataSet ds = new DataSet();
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            da.Fill(ds,"company");
            drpOrg.DataSource = ds.Tables[0];
            drpOrg.DataValueField = ds.Tables[0].Columns["id"].ToString();
            drpOrg.DataTextField = ds.Tables[0].Columns["orgname"].ToString();
            drpOrg.DataBind();
            //ddl1.items.insert(0, "Select"); 
            drpOrg.Items.Insert(0, "Select");
            con.Close();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
    }

i used to done select index change event on drop down list bt it's not working...

i want select index value of drop down list item into textbox....wat i do??? plz help me..

protected void drpOrg_SelectedIndexChanged(object sender, EventArgs e)
{
  string sCon = gv.constr;
     MySqlConnection con = new MySqlConnection(sCon);
       con.Open();
       String s = "Select companyid from companyuser where orgname='"+drpOrg.SelectedValue.ToString()+"'";
      MySqlCommand cmd = new MySqlCommand(s, con);
      MySqlDataReader dr = cmd.ExecuteReader();
       if (dr.Read())
      {
           txtCompanyid.Text = dr["companyid"].ToString();
      }
       else
       {
           txtCompanyid.Text = "";
      }
       con.Close();
   }

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 7

Reply
ANSWER
User: Mudassar
Replied: on Jun 07, 2013 01:56 AM
Report

Make sure you have set AutoPostBack = "true" and also defined SelectedIndexChanged event for the DropDownList

ashusing...

0 9

Reply
ANSWER
User: ashusingh
Replied: on Jun 07, 2013 03:04 AM
Report

Hi Rasika,

I have a made sample for you try this....

Html

 <asp:DropDownList ID="ddlOrgs" runat="server" AutoPostBack="true" OnSelectedIndexChanged="OnIndexChange">
        </asp:DropDownList>

Code

   protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                DataSet ds = this.GetData("SELECT [StateID],[StateName] FROM State", 0);
                this.Items.Clear();
                this.BindData(ds);
            }
        }

        private void BindData(DataSet ds)
        {
            this.ddlOrgs.DataSource = ds.Tables[0];
            this.ddlOrgs.DataTextField = ds.Tables[0].Columns[1].ToString();
            this.ddlOrgs.DataValueField = ds.Tables[0].Columns[0].ToString();
            this.ddlOrgs.DataBind();
            this.ddlOrgs.Items.Insert(0, new ListItem { Text = "Please Select", Value = string.Empty });
        }

        protected void OnIndexChange(object sender, EventArgs e)
        {
            DataSet ds = this.GetData("SELECT [CityId],[CityName] FROM City WHERE StateId = @StateId", int.Parse(this.ddlOrgs.SelectedItem.Value));
            this.BindData(ds);
        }

        private DataSet GetData(string query, int parameterValue)
        {
            DataSet ds = new DataSet();
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataAdapter da = new SqlDataAdapter();
            if (parameterValue > 0)
            {
                cmd.Parameters.Add("@StateId", DbType.Int32).Value = parameterValue;
            }
            da.SelectCommand = cmd;
            da.Fill(ds);
            return ds;
        }

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

ASP.Net DropDownList SelectedIndexChanged event not firing

Company

Explore

Follow us

Contact Us