Link to home
Start Free TrialLog in
Avatar of ptslv
ptslvFlag for United States of America

asked on

Problem with dropdown after binding arraylist

Hi folks.  I have a dropdown that I have successfully bound to arraylist.  My problem is that when I select an option, my insert statement is showing there is no value selected.  I am querying a table for the ratings that are to populate the dropdown.  The result is a string list, so I am interating thru the list to populate the arralylist, then binding to the dropdown. Please advise.  My code is below:


bool bIsError = false;
            alRatings = new ArrayList(1); // create arraylist to hold Possible Rating Responses
            alRatings.Add("");
            SqlConnection con = new SqlConnection(strConnection);
             string tempOption = "";
            try
            {
                SqlCommand cmd = con.CreateCommand();
                cmd.CommandText = "SELECT DISTINCT FormatType FROM t_Questions Where FormName= '" + formFilter + "' AND SeqNumber= " + tempSeqNum;
                con.Open();
                SqlDataReader dr = cmd.ExecuteReader();

                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        tempOption = dr["FormatType"].ToString();
                       
                    }
                 
                   
                    string[] strtemp = tempOption.Split(';');
                        foreach (string s in strtemp)
                        {
                            alRatings.Add(s);
                        }
                        alRatings.TrimToSize();
                    Rating.DataSource = alRatings;
                    Rating.DataBind();
                    con.Close();
                }
                else
                {
                    ........
                }
            }
            catch (Exception err)
            {.....
          }

INSERT Statement:

cmdInsert2.CommandText = "INSERT INTO t_Answers(CNTRL_NUM, Date, User, SeqNumber, " +
                        " Response, Comment)  VALUES( '" + CNTRL_NUM.Text + "', '" + Date.Text + "', '" + User.Text + "', " + SeqNumber.Text + ", '" + Rating.SelectedValue + "', '" + txtCmt.Text + "' );";
Avatar of ptslv
ptslv
Flag of United States of America image

ASKER

Sorry...I forgot to mention that my first option is empty.  If I remove the empty option, then the very first option is the resulting value regardless of what I select in the dropdown.
ASKER CERTIFIED SOLUTION
Avatar of Roopesh Reddy
Roopesh Reddy
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ptslv

ASKER

Thank you for the help.  I had moved it out of the (!Page.IsPostBack) and putting it back in there fixed my dropdown.