Login Code

Hey,

You know if i want to make a login feature on my site, i need to get the user to enter a ID no and password which are in the DB.

So i set up the connection and what would my query be??

when i say something like, Select Pword From Students Where etc. where does the value of Students.Pword get stored and how can i access it for authenticating the login??

I agree with MorningZ, but I've made something like this anyway, so here it is

Alright, you'll have to create a connection, a command, and a reader, like this.

Imports System.Data.OleDb
Public Function Login(UserId As String)
Dim DbConnection As New OleDbConnection, DbCommand As New OleDbCommand, DbReader As OleDbDataReader, LoginSucces As Boolean
With DbConnection
  'The connection string
  .ConnectionString = ""
  'Open the connection
  .Open()
End With
'Initialize the database command
With DbCommand
   .CommandText = "SELECT Pword FROM tblStudent WHERE UserId = '" & UserId & "'"
End With
Try
  DbReader = DbCommand.ExecuteReader()
  While DbReader.Read

     LoginSucces = True

  End While
  DbReader.Close
Catch

  LoginSucces = False
End Try
DbConnection.Close()
End Function

BTW, you're starting to look like mZeb, which is not a compliment. Please try it yourself first, and don't private message AND post a topic.

What I mean is, when you login, you'll have to find a combination between an user name and a password. That'll be harder then just guessing an user ID, which is probably a logic ID (so all the students have the same kind of id, but are slightly different).

That way it isn't really a 'Login', since you can just guess what kind of ID someone else has, and enter that.