query to fetch data according current date in asp.net C#

Question

con.Open();

 

SqlCommand cmd1 = new SqlCommand("SELECT [Description] FROM [tbl_Announcements] where Active = 1 AND ([ValidityDate] >= '" +DateTime.Today.ToLongDateString() + "')

 

cmd1.Connection = con;

 

SqlDataReader dr1 = cmd1.ExecuteReader();

while (dr1.Read())

{

k = dr1["Description"].ToString();

}

 

Label2.Text = k;

 

con.Close();