Simple Login Form code in ASP

asp

Ones the database is ready and you are sure that Login table in your database has enough values to perform an operation. You can apply this following code.

• All fields must be appropriate
• Form name and attribute names should match in the asp file

<%
dim conn
dim rs
dim    c_use
dim usertype
dim c_pass
dim query

set conn=server.CreateObject(“ADODB.connection”)
conn.Provider=”Microsoft.Jet.OLEDB.4.0″
conn.Open “C:Inetpubwwwrootsap1database.mdb”

set rs=server.createobject(“ADODB.recordset”)
query = “SELECT * FROM Login where c_use =” & “‘” & request.Form(“c_un”) & “‘” & ” AND ” &  “c_pass=” & “‘” & request.Form(“c_pswd”) & “‘”

rs.open query , conn

if rs.EOF  then

Response.redirect(“login_again.html”)

else

Response.redirect (“welcome.html”)

end if

set rs=nothing

conn.close

%>

Incoming search terms:

• Programming|TTC|Tech-check|SEO|Reviews|Gadgets|Technology (1)

Related posts:

1. asp code for a simple registration form