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
</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