VB.NET Login Verification

Expand Post »

Hi

I am creating an MDI application that asks the user for a User ID and Password to be able to show personal details once verified. Details of user ids and passwords are available in a MS Access Table1. There is another table2 for user details, and another one yet for transactions made by the user table3.

I have created the connection from access to vb.net through OLEDB.

The only outcome I have managed to produce is a datgrid showing all users, all passwords, and all transactions for each and every user. I.e. >> OleDbDataAdapter1.Fill(dsTable())

I need a procedure that asks the user for his ID and password, then once these are verified, only his appropriate details are shown. Example:

If txtUserID and txtPassword = True then
Show in label 1 Name
SHow in label 2 Surname
etc etc

Can somebody help with code ?

Similar Threads

Simple ASP.Net Login Page using C# in C#
Updated : Simple ASP.Net Login Page in ASP.NET
Simple ASP.Net Login Page (Using VB.Net) in ASP.NET

SerapH

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Oct 2007

Permalink

Oct 13th, 2007

Re: VB.NET Login Verification

Quote ...

Example:

If txtUserID and txtPassword = True then

while you configure your data adapter , the sql statment will be something like this

(Toggle Plain Text)

Select Name,  Surname from Tablel_name WHERE (id=?)

the question mark means that you will select specific row based on id (primary key)
then in your code you will verify that user entered correct information . after that replace the question mark with value you got from the user

(Toggle Plain Text)

OleDbDataAdapter.SelectCommand.Parameters("ID").Value = TextBox1.Text
        OleDbDataAdapter.Fill(DataSet)

Quote ...

Show in label 1 Name
SHow in label 2 Surname
etc etc

VB.NET Syntax (Toggle Plain Text)
Label1.Text = DataSet.Table_name.Rows(0).Item("Name") 
etc etc ..
Label1.Text = DataSet.Table_name.Rows(0).Item("Name") 
etc etc ..

hope that help you

Last edited by manal; Oct 13th, 2007 at 11:29 pm.

manal

Reputation Points: 37

Solved Threads: 17

Junior Poster

Offline

122 posts
since Mar 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: OleDbCommandBuilder isn't working

Next Thread in VB.NET Forum Timeline: HELP: Simple POS system in VB .NET

DaniWeb Message

Cancel Changes