login Prob

[josephrthomas]

hi..i am trying to make a login page and i am using access
table..
when the user enters his userid and password i want to
check the password from the table..

if any user with the userID that is entered exists i want
to find the correspoding password for him else i want to
throw an error saying no such user exists..

i know how to access the MS Access table and stuff..but
now what i want to do is to take the userid and see if
there is any userid such as the one existing, and if there
is i want to take out the password for that user ID..

what i am trying to do is as below.

The prob is, once i get the data in the dataset, how do i
take out the password??

i mean is there is any way i can assign the derieved
password to strPwd???
<code>
Private Sub cmdLogin_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles cmdFilter.Click

Dim strUserID As String = txtUserID.Text
Dim strPwd as string
Dim conn As OleDbConnection
Dim dsn As String =
ConfigurationSettings.AppSettings("ConnectionStrin g")

conn = New OleDbConnection(dsn)

Try
Dim da As OleDbDataAdapter
da = New OleDbDataAdapter("Select
[Password] from Customer where UserID ='" & strUserID
& "'", conn)

Dim ds As DataSet = New DataSet()
da.Fill(ds, "Customer")
'@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@
'HOW TO GET THE PASSWORD FROM THE
DATASET?????????????
'HOW TO ASSIGN THE PASSWORD IN THE DATASET
TO STRING strPwd???????
'strPwd = ???????????????
'@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@
Finally
conn.Dispose()
End Try
End Sub
*****************************************
can someone pls help me out????
is there any way i can take out the password that is
stored in the dataset and assign it to strPwd??
also how do i know that the userID could not be found in
the database and the dataset has nothing stored inside so
that i can tell the user that NO SUCH USER EXISTS!
can someone pls help me....
tks a lot...
any help deeply appreciated..
tks

[Alistair]

already answered. Please DO NOT multipost

"josephrthomas" <extremedotnet@yahoo.com.sg> wrote in message
news:041601c3cdd3$737c5ef0$a301280a@phx.gbl...

> hi..i am trying to make a login page and i am using access
> table..
> when the user enters his userid and password i want to
> check the password from the table..
>
> if any user with the userID that is entered exists i want
> to find the correspoding password for him else i want to
> throw an error saying no such user exists..
>
> i know how to access the MS Access table and stuff..but
> now what i want to do is to take the userid and see if
> there is any userid such as the one existing, and if there
> is i want to take out the password for that user ID..
>
> what i am trying to do is as below.
>
> The prob is, once i get the data in the dataset, how do i
> take out the password??
>
> i mean is there is any way i can assign the derieved
> password to strPwd???
> <code>
> Private Sub cmdLogin_Click(ByVal sender As System.Object,
> ByVal e As System.EventArgs) Handles cmdFilter.Click
>
> Dim strUserID As String = txtUserID.Text
> Dim strPwd as string
> Dim conn As OleDbConnection
> Dim dsn As String =
> ConfigurationSettings.AppSettings("ConnectionStrin g")
>
> conn = New OleDbConnection(dsn)
>
> Try
> Dim da As OleDbDataAdapter
> da = New OleDbDataAdapter("Select
> [Password] from Customer where UserID ='" & strUserID
> & "'", conn)
>
> Dim ds As DataSet = New DataSet()
> da.Fill(ds, "Customer")
> '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@
> 'HOW TO GET THE PASSWORD FROM THE
> DATASET?????????????
> 'HOW TO ASSIGN THE PASSWORD IN THE DATASET
> TO STRING strPwd???????
> 'strPwd = ???????????????
> '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@
> Finally
> conn.Dispose()
> End Try
> End Sub
> *****************************************
> can someone pls help me out????
> is there any way i can take out the password that is
> stored in the dataset and assign it to strPwd??
> also how do i know that the userID could not be found in
> the database and the dataset has nothing stored inside so
> that i can tell the user that NO SUCH USER EXISTS!
> can someone pls help me....
> tks a lot...
> any help deeply appreciated..
> tks
>
>

[Bullschmidt]

And here are a few felated issues about login pages on a Web site.

Perhaps have a login page that asks the user for his username and
password. And whatever page that posts to (which could be the same page
for a self posting form) tests these fields against what is in the
database, sets the username and userlevel session variables accordingly,
and then redirects to the proper page - i.e. back to the login page if
the password is wrong (perhaps with a JavaScript popup saying wrong
username/password combination) or to the main menu page if the password
is correct:

Session("UserName") = objRS("UserName")
Session("UserLevel") = objRS("UserLevel")
Response.Redirect "mainmenu.asp"

Then you can use If Then's or Select Case on each page to control
whether a user is allowed to actually be there and whether particular
links of where a user can go actually show up.

If (Session("UserLevel") <> "Admin") And (Session("UserLevel") <>
"Regular") Then
Response.Redirect "login.asp"
End If

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!