Simple ASP Query Question
<p>How can I make the SelectCommand use a textbox from the default page so that I can add that to the where clause? Please include an example I am new to programming and it helps me understand the concept better. thanks in advance.</p>

<blockquote>
  <p>Example WHERE (BADGE = 10000 + 
  xBadgeTextBox.Text)?</p>
</blockquote>

<pre><code>string Badge = "100000" + Request.Form["xBadgeTextBox"];

 &lt;asp:SqlDataSource ID="Time" runat="server" 
         ConnectionString="&lt;%$ ConnectionStrings:Time %&gt;" 
         ProviderName="&lt;%$ ConnectionStrings:Time.ProviderName %&gt;" 
         SelectCommand="SELECT CLOCK_IN_TIME, CLOCK_OUT_TIME, BADGE FROM CLOCK_HISTORY WHERE (BADGE = 100000342)"&gt; // use the badge number instead.
     &lt;/asp:SqlDataSource&gt;
</code></pre>
