try this
string value = dateTimePicker1.Value.ToString("MM/dd/yyyy");
string sql = "select Sno from Table1 where dt= @dt";
OleDbDataAdapter da = new OleDbDataAdapter(sql, connection);
da.SelectCommand.Parameters.AddWithValue("@dt", value);
da.Fill(dt);