p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB.NET (http://p2p.wrox.com/forumdisplay.php?f=83)
-   -   How to create the login (http://p2p.wrox.com/showthread.php?t=68160)

curiaquita May 16th, 2008 09:52 AM

How to create the login
 
Hi Guys,

Can you help me how to create a username and password so that anybody who want access the vb.net program login first.
Thanks,
Curiaquita


BrianWren May 16th, 2008 04:01 PM

What does your program do? The answer to that question might make some approches better for you than others.

Does it use a database?
If so, what kind (Oracle? SQL? Access?)?
Will this program be loded on the machine where each person uses it, or will it be on a network server?
Is it Web-based or windows forms-based?

curiaquita May 20th, 2008 01:02 PM

Hi Brian Wren,
The program is windows based-application and will use microsoft access to store the login details for each user who shall use the program. Users must login first before start using the program.

Any help will be appreciated.

Thanks,

Curiaquita


BrianWren May 23rd, 2008 02:58 PM

Create a table in Access, holding the login info. (You might want to build your own encryption routine to make these values hard to decypher.)
When a user logs in (that is, fills in a username and password textbox), try to open a recordset on that table
Code:

...
"WHERE USERNAME = """ & UName.Text & """ " & _
"  AND PASSWORD = """ & PWord.Text & """"

If the recordset is empty, they don't get logged in.

curiaquita June 4th, 2008 07:13 AM

Hi Brian,
Thank you for your help. I will do that.





All times are GMT -4. The time now is 07:31 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.