hello everyone
i want to firing my dropdownlist without autopostback, this is possible,
below my code
- protected void ddlIndustry_SelectedIndexChanged(object sender, EventArgs e)
- {
- StringBuilder builder = new StringBuilder();
- string sqlQueryOcc = "select SALARY_INDS_OCCNAME.INDUS_CAT_VAL,SALARY_INDS_OCCNAME.INDUS_CAT_NAME,SALARY_INDS_OCCNAME.INDUS_CAT_CODE from SALARY_INDS_OCCNAME ";
- sqlQueryOcc += " inner join SALARY_INDS";
- sqlQueryOcc += " on SALARY_INDS_OCCNAME.INDUS_CODE = SALARY_iNDS.INDUS_CODE ";
- sqlQueryOcc += " where SALARY_INDS.INDUS_CODE = '" + ddlIndustry.SelectedValue + "'";
- using (SqlCommand cmd = new SqlCommand(sqlQueryOcc))
- {
- cmd.CommandType = CommandType.Text;
- cmd.Connection = conn;
- conn.Open();
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- DataTable dt = new DataTable();
- da.Fill(dt);
- foreach (DataRow row in dt.Rows)
- {
- builder.AppendFormat("
- }
- conn.Close();
- }
- this.occList.Text = builder.ToString();
- }
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Thiruppathi RPosted May 19, 2016, 3:57 AM