So presumably, you have a suitable user information table set up in SqlCE?
Then it is just a case of creating a form, adding a username and a password field, and a "login" button.
You then check the details against the database, and either log them in or not as appropriate. I would use a hash for the password as usual (there is a tip here that may be worth reading
Password Storage: How to do it.[
^]), but it's nothing complex - what part of this is giving you difficulties?