i have dropdown list i select value from dropdown list when i select consultant name from dropdownlist i want to show email id of that consultant in listbox.how is this possible?
i write this code but it gives error
protected void DDConsultantName_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = ConfigurationManager.ConnectionStrings["Homeconstr"].ConnectionString;
cn.Open();
SqlCommand command = new SqlCommand("select ContactPerson_EmailID from Consultant_Detail where Consultant_Name=" + this.DDConsultantName.SelectedValue, cn);
SqlDataAdapter dataAadpter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
dataAadpter.Fill(ds);
LBEmailId.DataSource = ds;
LBEmailId.DataTextField = "ContactPerson_EmailID";
LBEmailId.DataBind();
}
when i select e.g morphees consultant from dropdown i want to show his email id in LBemail id listbox ?????????