
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”) & “‘”
conn.Provider=”Microsoft.Jet.OLEDB.4.0″
conn.Open “C:Inetpubwwwrootsap1database.mdb”
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:










It is essential to backup your personal information from your computer at least once a month. Some use a hard disk while others use cloud services like
A good Facebook fan page has become an essential for business both on and offline. Many marketers measure their success in social media by the number of likes or shares that they receive. When using
nice one
very useful!
Thanks!