Todays Date In WHERE Clause

Hello all

I have a simple DataSource control setup to a basic database that includes a datetime column, I want to retrieve records from today and beyond.

How do incorporate this into the Where clause?

Im getting stuck with the syntax too so a specific example would be most helpfull.This is the DataSource

<asp:SqlDataSource ID="ResultsSqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT  client, date FROM clients WHERE (client = @client)  Order by date asc ">
<SelectParameters>
<asp:controlparameter ControlID="TextBox1" Name="client" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>

If this requires code can you give C#

Thanks

Tino