How to filter DataGridView by dateTimePicker

See more:

C#3.5

Hi all have a datetimepicker and a datagridview in wins form, .Ideally I want a User to select date from datetimepicker and filtered data can show in datagridview row by row? My main purpose would like the user to pick up a date and return data fall in that date.But issue is my app is accessing an Access DB that was built and is used by another app and the date fields is in this Format

04/03/2015 11:23(dd/MM/yyyy mm:ss

whereas DateTimePicker is MM/DD/YYYY what can I do to achiever my goal ,below is the code am using in dateTimePicker Method to Filter my data, any suggestions?

DateTime dt = datetimepicker.Value;

//Connection string to connect to access database
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;";
using (var connection = new OleDbConnection(strConn))
{
    string strSql = String.Format("SELECT * FROM MYTABLE WHERE DateColumn = '{0}'", dt);
    using (var adap = new OleDbDataAdapter(strSql, connection))
    {
        DataTable table = new DataTable();
        adap.Fill(table);
        GridView1.DataSource = table;
        GridView1.DataBind();
    }
}