Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics 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
 
Old June 14th, 2007, 07:17 PM
Authorized User
 
Join Date: Jun 2007
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default login and password

here's the problem:
i need to make login screen to my application, which after u login goes to another form..i need someone to explain me how to check user name and password, and also i have to give users certain rights, for example - u can add new user, or smtng like that...but that goes to other form...
i thought of having table with id, name, surname, login, password and type of right...
base should be in sql, and environment is VB 2005
thnx for help, hope some answers soon..

 
Old June 15th, 2007, 02:57 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

Having posted an answer here, I found that you had posted this question more than once... Please don't post your question in multiple places. Rather, post the question in one forum, and post the URL in the other fora.

All: please see http://p2p.wrox.com/topic.asp?TOPIC_ID=61844

What I do in my internet app is this.

Users have an Oracle account as a feature of being a user.

When they submit their login and password, I use those credentials to try to communicate with Oracle. If Oracle accepts the communication, I keep the credentials. If not, I send back a webpage indicating that the credentials were no good.

You can try to communicate with the DB within your login form. If that fails, just don't move to the next form.

I do have user access configuration within the databse. If their login was successful, I go get their privileges, and give them controls (links in my case) to access the parts of the app that they have permission to access. You, of course, can have a variety of access controls (buttons, entries in listboxes, whatever), and can make them visible or not based on privileges, or you can have different forms for different classes of users. (Having multiple forms can be tough if the forms have similar features. If you make a change to a shared feature, you have to modify every form with a sililar feature... can be tedious.)

This answer is technology independent—these are approaches, and they would be implemented differently in different languages.
 
Old June 17th, 2007, 11:09 AM
Authorized User
 
Join Date: Jun 2007
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

all that you wrote is the way I imagined it too... my main problem is code which checks login and password from sql database because im total beginner in vb.

 
Old June 18th, 2007, 01:18 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

Well, I meant to make a distinction between holding user-base data in the database versus the users actually having an account in the database. Which is it that you have?
 
Old June 18th, 2007, 08:42 PM
Authorized User
 
Join Date: Jun 2007
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

well all data is stored in database - user name (irrelevant), login name, password and permission
 
Old June 18th, 2007, 09:22 PM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

airjaws, can you please keep your converstaion in the other thread that has expanded quite a bit??

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========




Similar Threads
Thread Thread Starter Forum Replies Last Post
login and password airjaws Pro Visual Basic 2005 18 June 19th, 2007 04:21 PM
Login Controls and Recover Password ~Bean~ ASP.NET 2.0 Professional 12 November 15th, 2006 03:13 PM
Login/Password Java application larry Apache Tomcat 2 December 20th, 2005 04:42 AM
Login with username and password morpheus Classic ASP Basics 4 November 19th, 2003 11:54 AM





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