|
-
Aug 6th, 2006, 04:44 AM
#1
Thread Starter
Junior Member
[RESOLVED] [2005] display info on textbox, urgent, pls help if possible
after i set a button to validate the id and password, i wana show the particualrs of that person in repective textboxes
like, name: name of the person
i use tis to do the validation
but i do not noe how to validate 2 fields, id n pw the same time
so after validating, how to do for showing the fields in the textboxes?
----------
Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\project\db1.mdb"
Dim con As OleDb.OleDbConnection
Dim dr As OleDb.OleDbDataReader
Dim cmd As New OleDb.OleDbCommand
Try
Dim strselect As String = "Select Id from member where BId = '" & IdTB.Text & "' and pw='" & pwTB.Text & "'"
'create a new connection
con = New OleDb.OleDbConnection(strcon)
con.Open()
cmd.Connection = con
cmd.CommandText = strselect
dr = cmd.ExecuteReader
Catch eException As Exception
MessageBox.Show(eException.Message)
End Try
------------------------
pls help, i need to submit tis project b4 9am tml >.<
my 1st project on vb so errr..... nothing too complicated pls >.<
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|