ptslv
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(strConnectio n);
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 + "' );";
bool bIsError = false;
alRatings = new ArrayList(1); // create arraylist to hold Possible Rating Responses
alRatings.Add("");
SqlConnection con = new SqlConnection(strConnectio
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 + "' );";
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you for the help. I had moved it out of the (!Page.IsPostBack) and putting it back in there fixed my dropdown.
ASKER