title: Using now() in a <asp:textbox>
body: <p>Can anyone help.  I am using a formview in VS 2005.  I have different elements in my form databound to a database and I am performing an INSERT SQL statement.  No problem.  The problem is that I am trying to enter the current date into the SQL statement and I am having a problem.</p>
  
  <p>I can add &lt;%now()%> to the "Text" property of the asp:Textbox.  But when I do, then I can't bind the textbox to a specific database column. </p>
  
  <p>How do I do both????</p>
  
  <p>I can do this:</p>
  
  <pre><code>&lt;asp:TextBox ID="TextBox2" runat="server" Text='&lt;%# Bind("Initiate_Date") %&gt;' &gt;&lt;/asp:TextBox&gt;
  </code></pre>
  
  <p>Or this:</p>
  
  <pre><code>&lt;asp:TextBox ID="TextBox2" runat="server" Text='&lt;%# now() %&gt;' &gt;&lt;/asp:TextBox&gt;
  </code></pre>
  
  <p>But I don't know how to do both.</p>