This is my code...
Sub btnLogin_OnClick(Src As Object, E As EventArgs)
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim intUserCount As Integer
Dim strSQL As String
strSQL = "SELECT COUNT(*) FROM tblLoginInfo WHEREusername=@.UserName AND
password=@.Password"
myConnection = New SqlConnection("server=
(local);database=Database;trusted_connection=true")
myCommand = New SqlCommand(strSQL, myConnection)
myCommand.Parameters.add("@.UserName",sqldbtype.varchar).value=txtUserName.text
myCommand.Parameters.add("@.Password",sqldbtype.varchar).value=txtPassword.text
myConnection.Open()
intUserCount = myCommand.ExecuteScalar()
myConnection.Close()
If intUserCount > 0 Then
lblInvalid.Text = ""
FormsAuthentication.SetAuthCookie(txtUsername.Text, True)
Response.Redirect("login_db-protected.aspx")
Else
lblInvalid.Text = "Sorry... try again..."
End If
End Sub
On the table 'tblLoginInfo' there are 3 fields... username, password and destination.
When a user clicks on the btnLogin... i want to get the value of the destination field that
lines up with the same username and password fields and place it in a string called 'test'.
Cannning
Hi, just replace count(*) with destination:
strSQL = "SELECT destination FROM tblLoginInfo WHEREusername=@.UserName AND
password=@.Password"
myConnection = New SqlConnection("server=
(local);database=Database;trusted_connection=true")
myCommand = New SqlCommand(strSQL, myConnection)
myCommand.Parameters.add("@.UserName",sqldbtype.varchar).value=txtUserName.text
myCommand.Parameters.add("@.Password",sqldbtype.varchar).value=txtPassword.text
myConnection.Open()
string test = (string) myCommand.ExecuteScalar ( ) ;
myConnection.Close()
Hope this helps
