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.EventArg s) Handles cmdFilter.Click
Dim strUserID As String = txtUserID.Text
Dim strPwd as string
Dim conn As OleDbConnection
Dim dsn As String =
ConfigurationSe ttings.AppSetti ngs("Connection String")
conn = New OleDbConnection (dsn)
Try
Dim da As OleDbDataAdapte r
da = New OleDbDataAdapte r("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
</code>
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