Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
VB.NET General VB.NET discussions for issues that don't fall into other VB.NET forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 16th, 2008, 09:52 AM
Authorized User
 
Join Date: Apr 2008
Location: newcastle upon tyne, tyne and wear, United Kingdom.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

  #2 (permalink)  
Old May 16th, 2008, 04:01 PM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

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?
  #3 (permalink)  
Old May 20th, 2008, 01:02 PM
Authorized User
 
Join Date: Apr 2008
Location: newcastle upon tyne, tyne and wear, United Kingdom.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

  #4 (permalink)  
Old May 23rd, 2008, 02:58 PM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

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.
  #5 (permalink)  
Old June 4th, 2008, 07:13 AM
Authorized User
 
Join Date: Apr 2008
Location: newcastle upon tyne, tyne and wear, United Kingdom.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help - How to create a Login tracker? melvados Visual Basic 2005 Basics 3 August 4th, 2008 09:07 AM
Blog - Can login but, cannot create new entry j.t.w BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 13 January 24th, 2007 03:15 PM
How to create Cookies and use login page +checkbox lily611 General .NET 6 October 12th, 2004 01:59 PM
HELP! Create login with DreamweaverMX/Access 2002 aepling Access ASP 1 January 30th, 2004 12:19 PM
Please Help! Attempt to create a login page nvillare Classic ASP Basics 8 August 12th, 2003 09:06 PM





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