Fill a Listbox with value selected from a Dropdownlist in asp.net

Question

0.00/5 (No votes)

See more:

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

C#

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.DataValueField = "Id";
       LBEmailId.DataBind();
       }

when i select e.g morphees consultant from dropdown i want to show his email id in LBemail id listbox ?????????

Posted 2-Oct-12 20:16pm

16041984

Updated 2-Oct-12 20:43pm

DaveAuld

v2

Add a Solution

Comments

Mohd. Mukhtar 3-Oct-12 3:16am

What error exactly you are getting??

AshishChaudha 3-Oct-12 4:45am

have you checked dataset..are you getting the email ID of the selected value??

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2012-10-02T20:57:00

Solution 1

Try this:

C#

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);
    if(ds != null){
        LBEmailId.DataSource = ds.Tables[0];
        LBEmailId.DataTextField = "ContactPerson_EmailID";
        //LBEmailId.DataValueField = "Id";
        LBEmailId.DataBind();
    }
}

Hope it helps!
--Amit

Posted 2-Oct-12 20:57pm

_Amy

Comments

16041984 3-Oct-12 3:20am

when i use this it is running but not showing any result in listboxemailid i.e LBEmailID.pls help

ujju.1 3-Oct-12 3:31am

have you set AutoPostBack="True" for DDConsultantName?

16041984 3-Oct-12 3:45am

yes i set autopostback = true for dropdown
<asp:DropDownList ID="DDConsultantName" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DDConsultantName_SelectedIndexChanged">

it shows

Mohd. Mukhtar 3-Oct-12 4:05am

put break point and check if anything is coming in ds.Tables[0];

16041984 3-Oct-12 4:59am

i will do one thing i take one textbox then add email id's in listbox ....problem solved....thank u for ur reply all of u

16041984 3-Oct-12 4:59am

if (DDConsultantName.SelectedIndex != 0)
{
string strValue = string.Empty;
cn.Open();
//SqlConnection con = new SqlConnection("server=servername;uid=sa;password=p@ssw0rd;database=test;Connect Timeout=200; pooling='true'");
SqlCommand cmd = new SqlCommand(" select ContactPerson_EmailID from Consultant_Detail where Consultant_ID='" + DDConsultantName.SelectedValue.ToString() + "'", cn);
//cn.Open();
strValue = (string)cmd.ExecuteScalar();
cn.Close();
TextBox1.Text = strValue;
// LBEmailId.DataTextField = "ContactPerson_EmailID";
// LBEmailId.DataValueField = "Consultant_ID";

}