Why is the change in an html input textbox not being detected in asp.net?[Answered] RSS

• • Reply
  bigyeti

  Member

  19 Points

  102 Posts

  Why is the change in an html input textbox not being detected in asp.net?

  Mar 27, 2021 09:02 PM|bigyeti|LINK

  I have a repeater, one columm of which contains a textbox on which is attached a JQuery datepicker along with an update button. So a user uses the datepicker to change the date, clicks update and it writes to the database.The original date and the record id are stored in hidden fields.

  <asp:Repeater ID="Repeater1" runat="server">
  <ItemTemplate>
  <tr>
  <td>
  <asp:HiddenField ID="hidThisID" Value='<%# Eval("orderID") %>' runat="server" />
  <asp:HiddenField ID="hidPrevDueDate" Value='<%# Eval("Duebeforedate", "{0:dd/MM/yyyy}") %>' runat="server" />
  <input type="text" class="form-control fc-datepicker duedateinput" style="width: 150px" value='<%# Eval("Duebeforedate", "{0:dd/MM/yyyy}") %>'  runat="server" id="fccd" readonly />
  <asp:LinkButton ID="btnDateUpdate" OnClick="btnDateUpdate_Click" CssClass="btn btn-primary btn-sm" runat="server" ToolTip="Approved"> Update </asp:LinkButton>
  </td>
  </tr>
  </ItemTemplate>
  </asp:Repeater>

  Which calls this function - 

  protected void btnDateUpdate_Click(object sender, EventArgs e)
      {
          foreach (RepeaterItem item in Repeater1.Items)
          {
              HtmlInputText htmlDueDate = (HtmlInputText)item.FindControl("fccd");
              HiddenField hidID = (HiddenField)item.FindControl("hidThisID");
              HiddenField hidOldDate = (HiddenField)item.FindControl("hidPrevDueDate");
              DateTime prevDueDate = Convert.ToDateTime(hidOldDate.Value.ToString());
              DateTime newDueDate = Convert.ToDateTime(htmlDueDate.Value.ToString());
              string ID = hidID.Value;
              if (prevDueDate != newDueDate)
              {
                  string query = "update [tblOrders] set Duebeforedate=CONVERT(datetime,'" + newDueDate.ToString() + "', 103) where  [orderID] =  '" + ID + "'";
                  
                  //database stuff here
              }
          }
      }

  However, the newDueDate variable still holds the original due date. Consequently the old and new dates match and so the database doesn't get updated. How do I get it to store the new value?

• • Reply
  SurferOnWww

  Member

  390 Points

  280 Posts

  Re: Why is the change in an html input textbox not being detected in asp.net?

  Mar 27, 2021 10:52 PM|SurferOnWww|LINK

  Please use Bind method instead of Eval method.

• • Reply
  bigyeti

  Member

  19 Points

  102 Posts

  Re: Why is the change in an html input textbox not being detected in asp.net?

  Mar 27, 2021 11:59 PM|bigyeti|LINK

  I did change it to 

  <input type="text" 
  class="form-control fc-datepicker duedateinput" 
  style="width: 150px"
  value='<%# Bind("Duebeforedate", "{0:dd/MM/yyyy}") %>'
  runat="server" 
  id="fccd"
  readonly />

  But the same occurs, newDueDate holds the original value as in prevDueDate

• • Reply
  SurferOnWww

  Member

  390 Points

  280 Posts

  Re: Why is the change in an html input textbox not being detected in asp.net?

  Mar 28, 2021 01:02 AM|SurferOnWww|LINK

  bigyeti

  <input type="text"
  class="form-control fc-datepicker duedateinput"
  style="width: 150px"
  value='<%# Bind("Duebeforedate", "{0:dd/MM/yyyy}") %>'
  runat="server"
  id="fccd"
  readonly />

  Remove readonly and try again.

• • Reply
  bigyeti

  Member

  19 Points

  102 Posts

  Re: Why is the change in an html input textbox not being detected in asp.net?

  Mar 28, 2021 01:14 AM|bigyeti|LINK

  Makes no difference. Besides it needs to be readonly so they have to use the datepicker.

• • Reply
  SurferOnWww

  Member

  390 Points

  280 Posts

  Re: Why is the change in an html input textbox not being detected in asp.net?

  Mar 28, 2021 02:35 AM|SurferOnWww|LINK

  I cannot reproduce your problem with the following sample similar to yours. I guess that something not shown in your code causes the issue.

  .aspx.cs

  using System;
  using System.Web.UI.WebControls;
  using System.Web.UI.HtmlControls;
  
  namespace WebApplication2
  {
      public partial class RepeaterDatePicker : System.Web.UI.Page
      {
          protected void Page_Load(object sender, EventArgs e)
          {
  
          }
  
          protected void Button1_Click(object sender, EventArgs e)
          {
              foreach (RepeaterItem item in Repeater1.Items)
              {
                  HtmlInputText htmlDueDate = (HtmlInputText)item.FindControl("fccd");
                  DateTime newDueDate = Convert.ToDateTime(htmlDueDate.Value.ToString());
              }
          }
      }
  }

  .aspx

  <%@ Page Language="C#" AutoEventWireup="true" 
      CodeBehind="RepeaterDatePicker.aspx.cs" 
      Inherits="WebApplication2.RepeaterDatePicker" %>
  
  <!DOCTYPE html>
  
  <html xmlns="http://www.w3.org/1999/xhtml">
  <head runat="server">
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
      <title></title>
      <script src="Scripts/jquery-3.4.1.js"></script>
      <script src="Scripts/jquery-ui-1.12.1.js"></script>
      <link href="Content/themes/base/jquery-ui.css" rel="stylesheet" />
      <script type="text/javascript">
          //<![CDATA[
          $(function () { 
              $('table input:text[id*=fccd]')
              .datepicker(); 
          });
  //]]>
      </script>
  </head>
  <body>
      <form id="form1" runat="server">
          <div>
              <asp:SqlDataSource ID="SqlDataSource1" 
                  runat="server" 
                  ConnectionString="<%$ ConnectionStrings:NORTHWINDConnectionString %>" 
                  SelectCommand="SELECT TOP 1 [OrderID], [CustomerID], [OrderDate] FROM [Orders]">
              </asp:SqlDataSource>
              <asp:Repeater ID="Repeater1" 
                  runat="server" 
                  DataSourceID="SqlDataSource1">
                  <HeaderTemplate>
                      <table>
                          <tr>
                              <th>OrderID</th>
                              <th>CustomerID</td>
                              <th>OrderDate</th>
                          </tr>
                  </HeaderTemplate>
                  
                  <ItemTemplate>
                      <tr>
                          <td><%# Eval("OrderID")%></td>
                          <td><%# Eval("CustomerID")%></td>
                          <td>
                              <input type="text"
                                  style="width: 150px"
                                  value='<%# Bind("OrderDate", "{0:dd/MM/yyyy}") %>'
                                  runat="server"
                                  id="fccd"
                                  readonly />
                          </td>
                      </tr>
                  </ItemTemplate>
  
                  <FooterTemplate>
                      </table>
                  </FooterTemplate>
              </asp:Repeater>
          </div>
          <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
      </form>
  </body>
  </html>

  
  
   

• • Reply
  oned_gk

  All-Star

  52803 Points

  15764 Posts

  Re: Why is the change in an html input textbox not being detected in asp.net?

  Mar 28, 2021 05:33 AM|oned_gk|LINK

  Ensure, the repeater is not rebind every postback

  if (!IsPostBack)
  {
       //bind the repeater
  }

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  bigyeti

  Member

  19 Points

  102 Posts

  Re: Why is the change in an html input textbox not being detected in asp.net?

  Mar 28, 2021 04:48 PM|bigyeti|LINK

  Brilliant, that's fixed it.