|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
March 9th, 2004, 03:49 AM
|
|||
|
|||
|
need some help here!
how do i (in vb.net) cause the program to verify a
user's input (in the textbox) with the information that is already in the database (ms access), that is after the user clicks on a button? something like a authentication process, just not quite. i'm new with vb.net... can anyone help me?
|
|
#2
June 7th, 2004, 09:06 PM
|
|||
|
|||
|
no thanks...
i know how to validate the user input in the database but the thing is, i'm using an SQL Server with ADO.NET not the one you said i don't know what is the different on the two...
|
|
#4
June 12th, 2004, 01:07 AM
|
|||
|
|||
|
There are 3 main steps.
1) get user input 2) Format a SQL query 3) Qeury db and get the result. (Note: I did not test this code for syntax errors / compilation errors. Please type this code into VS.NET editor to check for any minor issues) Code: Code:
'Step 1
Dim userNameStr, userPwdStr as string
userNameStr = trim(txtUserName.text)
userPwdStr = trim(txtUserPwd.text)
'step 2
Dim userExistsQry as string
userExistsQry= "Select * from tableName where colUserName = '" & userNameStr & " ', colUserPwd='" & userPwdStr & "'"
'Step 3
mySqlConnection = New SqlConnection("data source=dsName;integrated security=SSPI;database=dbName; persist security info=False;workstation id=wsName;packet size=4096") 'u can use your own conn string
mySqlCommand = New SqlCommand(selectSqlString, mySqlConnection)
Try
mySqlConnection.Open()
myDataReader = mySqlCommand.ExecuteReader(CommandBehavior.CloseCo nnection)
'Always call Read before accessing data.
DoWhile (myDataReader.Read())
userFound = True
Loop
Catch ex As System.Exception
Finally
If (mySqlConnection.State = ConnectionState.Open) Then
mySqlConnection.Close()
EndIf
EndTry
________________________ Web reading made easy - URL
|
|
| Viewing: Dev Articles Community Forums > Programming > .NET Development > need some help here! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
