When i turn on my sansa e270r it says"refresh database" but the bar wont move at all and i cant do anything

You don't have to do anything. Just wait and let the Sansa refresh its database. It shows a progress bar to indicate progress.

You can download the manual from
http://www.sandisk.com/sandisk-support/warranty-and-user-guides

Some songs or files with extension device can't read, so it takes so long/infinity to refresh. Plug the device to pc, format it.
Good luck

I finally learned how to go into recovery mode, and followed directions to reformat my e260, by Oreo123. :D

http://www.sansa.com/support/sansa_e200/faqs

STEP 1 – Reset the device

1. Press the Power button and hold it for approximately 10 seconds.
2. Release the Power button once the device is powered down.
3. Turn the device back on.

STEP 2 – Download and Install the Sansa Firmware Updater


If that does not fix it, please post a comment with an update to your problem.

1ST: Just try to 'reset' by holding down the main center button AND pushing UP on the lock/off-on button, for about 8-9 seconds,
It will then 'refresh' the database, shouldn't lose anything,
OR:
MANY problems can be fixed ultimately by the following;
REFORMAT the SansaDisk Clip by finding it in My Computer and right click then just 'format' the thing. THEN drag and drop new music into it (or books), DRAG and DROP, you apparently erase the thing with a 'FORMAT' ....BUT - it's .sys files remain and it is like new {as in empty}
This usually fixes almost anything, should even erase a virus (I'm guessing) but shouldn't hurt it.
Good Luck!

-simple 'drag and drop' from my MUSIC folder seems to work just fine for me...

Try holding the power button for about 15-20 seconds. This usally shuts the whole thing down.

It may refresh the database as normal next time.

Turn it on into recovery mode (Hold + Record Button + Power)
Connect to computer (You should detect a 16MB drive)
Make an empty text file inside the 16MB Drive and rename it to "sansa.fmt"
Unplug the Sansa. You should see now a "Formatting..." on the Sansa's screen.
Sansa fixed!

Get the Vista compatible version of the software from Sansa's website

Have you removed the battery, wait then reinstall it to try to reset it? Been the Sansa website and their FAQ or tech support?

The same thing happened to me. I just called the support number, and they e-mail you a firmware upgrade. It solved all my problems with it.