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??

From this http://www.asp.net/Tutorials/quickstart.aspx - set of tutorials

Comes this section, http://www.dotnetjunkies.com/quickstart/aspplus/doc/formsauth.aspx - Security

at some point you are going to have to do some research on your own instead of just leaning on a message board to solve every problem :-/

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.

For your information I have tried it myself and cant solve the problem of figuring out away of using the value returned when i search for the pword in the table.

And morning Z ive looked at those tutorials and they gave me some of the ideas im using.

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.