Does anyone have VB code that correctly adds a new user to an SQL Server database? I assume it has to use sp_addlogin and/or sp_adduser, but I'm not sure.

For example, I'd like to add user "myname" to a database so they can subsequesntly log in. Anyone know how to do this?

Also, if anyone can suggest a quick read on this subject, I'd appreciate it.