Dropdown problem with common values of datavaluefield

Question

0.00/5 (No votes)

See more:

Hi I've a dropdown list with datasource like
empname dept
-----------------
Rahul 02
martin 01
sachin 02

i've binded this table to my dropdown list and when i try to access dept in dropdown selected event change every time I'm getting Rahul only. even i selected sachin.

Whats the problem? What I assume is I've two common values in my datavalue field (02 and 02) is this a problem?

Please check my code shown below..

C#

if (!IsPostBack)
       {
 try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("toget_emp", con);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    ddlReason.DataSource = ds.Tables[0];
                    ddlReason.DataTextField = "empname";
                    ddlReason.DataValueField = "dept";
                    ddlReason.DataBind();
                    ddlReason.Items.Insert(0, "--Select--");
                }
            }
            catch (SqlException ex)
            {
                ScriptManager.RegisterStartupScript(this, GetType(), "alert", "javascript:alert('" + ex.Message + "')", true);
            }
            finally
            {
                con.Close();
            }
        }

Posted 3-Jul-13 2:59am

Suri Rayal

Updated 3-Jul-13 3:08am

Thanks7872

v2

Add a Solution

Comments

[no name] 3-Jul-13 9:02am

How is this any different than the exact same question that you already asked, http://www.codeproject.com/Questions/615222/Dropdown-problem-with-common-values?

jaideepsinh 3-Jul-13 9:05am

Why you not use primary key set primary key to DataValueField .

3 solutions

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)

M.R.A. · Answer 1 · 2013-07-03T03:12:00

Solution 1

Write code like this

ddlReason.DataBind();
ddlReason.Items.Insert(0, "--Select--";);
ddlReason.Items[0].value="0";

Posted 3-Jul-13 3:12am

M.R.A.

Mayank Dubey · Answer 2 · 2013-07-03T08:31:00

Yes ,It would be the problem but you can use DropDownList's SelectedIndex property and catch selected value and text in DropDownList onselectedindexchanged="ddlReason_SelectedIndexChanged" to get selected text field even you have same value in value field ,But it's suggested to use unique value in DataValueField.

C#

protected void ddlReason_SelectedIndexChanged(object sender, EventArgs e)
  {
      DropDownList ddl = (DropDownList)sender;
      int index = ddl.SelectedIndex;
      string Text = ddl.SelectedItem.ToString();
      string Value = ddl.SelectedValue;

  }

Masoom Mir · Answer 3 · 2013-07-03T20:16:00

Solution 3

You can use Rahul id as 02 and sachin id as 002 or

Dont use deptid u should use empid which is unique for all records...

Posted 3-Jul-13 20:16pm

Masoom Mir