Get selected value from a dropdownlist asp.net

Question

I know this is a silly question but i can't find out how to get the selected value from my dropdownlist :(

Init the dropdownlist:

             SqlCommand command = new SqlCommand("SelectAllUserID", connection);
             command.CommandType = CommandType.StoredProcedure;

            SqlDataReader sqlReader = command.ExecuteReader();
            if (sqlReader.HasRows)
            {
                TProjectMID.DataSource = sqlReader;
                TProjectMID.DataTextField = "UserID";
                TProjectMID.DataValueField = "UserID";
                TProjectMID.DataBind();
            }

Try to get the value of drop down list:

                String a;
                a = TProjectMID.SelectedValue;
                a = TProjectMID.SelectedItem.Value;
                a = TProjectMID.DataValueField;
                a = TProjectMID.Text;

It didn't return the value I chose, it keeps returning the default value when the dropdownlist appear ??

Can anybody tell me what I did wrong ? Thank you

well .. are you binding within a if(!IsPostBack) ,if not do so and check out — V4Vendetta
– V4Vendetta, Commented Aug 11, 2011 at 11:20

E.J. Brennan · Accepted Answer · 2011-08-11 11:24:22Z

You need to make sure you are not re-loading the DDL everytime the page loads, in other words only fill it on the initial page load, and if it is a page postback, don't re-load it so the value will be retained.

Something like this should work:

   protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack) {

         SqlCommand command = new SqlCommand("SelectAllUserID", connection);
         command.CommandType = CommandType.StoredProcedure;

          SqlDataReader sqlReader = command.ExecuteReader();
          if (sqlReader.HasRows)
          {
            TProjectMID.DataSource = sqlReader;
            TProjectMID.DataTextField = "UserID";
            TProjectMID.DataValueField = "UserID";
            TProjectMID.DataBind();
          }
        }

}

and then in your code to retrieve the value, this should work:

   string a = TProjectMID.SelectedValue;

Baz1nga · Accepted Answer · 2011-08-11 11:22:10Z

0

have you made sure that you have set a value on the options for the value to be returned?

something like this

<select>
<option value="I am foo">foo</option>
<option value="I am bar">bar</option>
</select>

answered Aug 11, 2011 at 11:22

Baz1nga

15.6k3 gold badges38 silver badges63 bronze badges

1 Comment

V4Vendetta Over a year ago

Does this make sense, he is binding the fields ?

Collectives™ on Stack Overflow

Get selected value from a dropdownlist asp.net

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related