How to query with dates from SQL Server after today's date
<p>I'm trying to query my database with ADO.NET</p>

<pre><code>string con = "Data Source=xx.xx.xx.xx\\SqlExpress;Network Library=DBMSSOCN; Initial Catalog=DB;User ID=ID;Password=xxxxx;";
SqlConnection connection = new SqlConnection(con);

using (connection)
{
    string query = "SELECT * FROM Gigs where Date &gt;= GetDate()";

    SqlCommand command = new SqlCommand(query, connection);

    var da = new SqlDataAdapter();
    connection.Open();

    SqlDataReader reader = command.ExecuteReader();
    da.SelectCommand = command;

    connection.Close();

    var ds = new DataSet();
    da.Fill(ds);

    gigs.DataSource = ds;
    gigs.DataBind();
}
</code></pre>

<p>The code executes fine, but it shows incorrect values. I was expecting to see only dates after today. Yet, I see values from the past and future. It's as if the query is simply <code>SELECT * from Gigs</code></p>

<p>In SQL Server, the column <code>Date</code> is of type <code>date</code>.</p>

<p>What have I done wrong?</p>