var dateString = DateTime.Now.ToShortDateString();
DateTime dt = DateTime.ParseExact(dateString,
System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern,
System.Globalization.CultureInfo.CurrentCulture);
using (OleDbConnection con = new OleDbConnection(strConnect))
{
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * TABLENAME WHERE COLNAME= ?", con);
da.SelectCommand.Parameters.AddWithValue("@Date", dt.Date);
DataTable dt = new DataTable();
da.Fill(dt);
yourgridview.DataSource = dt;
}