|"ok, the second drive I got open with a needle , just to find there was no CD inside, after I pressed the button for it to close , it stayed shut again,..."|
If the led on the front of the drive does not light up when you press the button for ejecting or retracting the CD while the computer is running, the drive's board is fried.
If this is a desktop drive, if you open the tray by pushing in a needle or wire, there is usually a small rubber belt, usually it's black, that is supposed to run between two small pulleys, that you can find near the front of the drive below the tray by looking through the holes in the tray, when there is no disk on the tray. That belt must be there and be adequate, otherwise the tray mechanism cannot retract and eject. Sometimes that belt has fatigued such that it it slips on the pulleys, or the belt has broken. You can use an elastic band of the right size and tension to replace that belt, then the tray will often then open and close fine (e.g. get yourself a bag of assorted sizes of elastic bands from a "dollar" store).
To find out whether you should bother doing that, with the data cable connected to the drive, insert a disk that the drive can read into the tray, close the tray, and see if Windows recognizes the disk. If it does, try replacing the belt.