Hi,
I know this is really basic question but it has left me completely stumped... I have a user login page where a user enters their email address and password and I am wanting to store additional information that is in the database for the user into session.
The behind code for my login page is below but I just can't get my head around it and it's frustrating me no end...
Imports System.Data.OleDb
Partial Class Login
Inherits System.Web.UI.Page
Protected Sub Login_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Login.Click
Dim connect As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\SiteMan.accdb;Persist Security Info=False;"
Dim query As String
query = "Select Count(*) From Consultants Where EmailAddress = ? And Password = ?"
Dim result As Integer = 0
Using conn As New OleDbConnection(connect)
...
Go to the complete details ...