Getting values from textbox in item template

[Henry Franzoni]

In the ListBox ItemTemplate Demo, a numeric textbox is included to allow users to enter order Quantity. No problem creating a similar item template. No problem passing item.Value to SqlParameter and inserting to database. But I cannot figure out how to grab a value from a textbox and pass that as another parameter.

Code below passed an empty string or NULL to @Quantity: 

 

 foreach (RadListBoxItem item in collection)
                {
                    cmd4.Parameters.Clear();
                    cmd4.Parameters.AddWithValue("@Product_ID", item.Value);
                    cmd4.Parameters.AddWithValue("@Quantity", Convert.ToInt32(item.FindControl("RadNumericTextBox1.Text") as TextBox));
                    cmd4.ExecuteNonQuery();
                }​

A few articles I found suggest textbox values are lost during postback? Anyone else run into this problem? Advice appreciated.

 

                              

[Henry Franzoni]

PS - my item template:

  <ItemTemplate>
                                    
                            
                          <asp:Table runat="server">
                              <asp:TableRow>
                                  <asp:TableCell Width ="300px">
                                    <%# DataBinder.Eval(Container, "Text")%>
                                  </asp:TableCell>
                                  <asp:TableCell>
                                        <label>
                                    Quantity:</label>
                                      <telerik:RadNumericTextBox runat="server" ID="QuantityTextBox" Width="60px" MinValue="0"
                                    MaxValue="1000" ShowSpinButtons="true" Value="0" NumberFormat-DecimalDigits="0">
                                </telerik:RadNumericTextBox>
                                  </asp:TableCell>
                              </asp:TableRow>

                          </asp:Table>
                         
                       </ItemTemplate>​

[Aneliya Petkova]

Hi Henry,

Please note that .FindControl method takes the searched control's ID as an argument. So in your case, there is no control with RadNumericTextBox1 ID in the ItemTemplate of the RadListBox. The following line of code:

cmd4.Parameters.AddWithValue("@Quantity", Convert.ToInt32(item.FindControl("RadNumericTextBox1.Text") as TextBox));

should be changed with something like this:

cmd4.Parameters.AddWithValue("@Quantity", Convert.ToInt32(((RadNumericTextBox)item.FindControl("QuantityTextBox")).Text));

Hope this will be helpful.

Regards,
Aneliya Petkova
Telerik