CorstianBoerman

asp.NET login

Sep 9th, 2011
222
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 1.85 KB | None | 0 0
  1. Imports System.Data.SqlClient
  2.  
  3. Public Class login
  4.     Inherits System.Web.UI.Page
  5.  
  6.     Dim ErrorHandling As New ErrorHandling
  7.     'ErrorHandling is dan een class van mij die controleert op o.a. sql injection.
  8.     Dim SqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("CorstianBoerman").ToString)
  9.  
  10.     Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
  11.         If Session("LoggedIn") = True Then
  12.             Server.Transfer("index.aspx")
  13.         End If
  14.     End Sub
  15.  
  16.     Protected Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click
  17.  
  18.         Dim User As String
  19.         Dim Pass As String
  20.  
  21.         User = txtUser.Text
  22.         Pass = txtPass.Text
  23.  
  24.         If ErrorHandling.CheckSql(User) = True Then
  25.             Exit Sub
  26.         ElseIf ErrorHandling.CheckSql(Pass) = True Then
  27.             Exit Sub
  28.         End If
  29.  
  30.         Dim SqlQuery As String
  31.         SqlQuery = "SELECT * FROM tblUsers WHERE fld_username='" & User & "' AND fld_password='" & Pass & "'"
  32.  
  33.         Dim SqlComm As New SqlCommand(SqlQuery, SqlConn)
  34.  
  35.         SqlConn.Open()
  36.  
  37.         Dim SqlReader As SqlDataReader = SqlComm.ExecuteReader
  38.  
  39.         If SqlReader.HasRows Then
  40.  
  41.             Dim intId As Integer
  42.             Dim strUser As String
  43.             Dim strPass As String
  44.  
  45.             intId = SqlReader.GetInt32(0)
  46.             strUser = SqlReader.GetString(1)
  47.             strPass = SqlReader.GetString(2)
  48.  
  49.             If strUser = User And strPass = Pass Then
  50.                 Session("ID") = intId
  51.                 Session("User") = strUser
  52.         Server.Transfer("~/index.aspx")
  53.             Else
  54.                 lblMessage.Text = "Wrong username and/or password!"
  55.             End If
  56.  
  57.         Else
  58.             lblMessage.Text = "Wrong username and/or password!"
  59.         End If
  60.  
  61.     End Sub
  62. End Class
Advertisement
Add Comment
Please, Sign In to add comment