<%
if Session("UserName")="" then
%>
|
You are not authorised User. Please login
|
<%
else
id=request.querystring("id")
dim strCon
set Connect=Server.CreateObject("ADODB.connection")
strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& Server.MapPath("database/db.mdb") _
& ";User ID=;"
Connect.ConnectionString = strCon
if Connect.State=1 then Connect.Close
Connect.open
set rs = Server.CreateObject("ADODB.Recordset")
Sql="select * from emp where id=" & id & ""
on error resume next
rs.Open SQL,Connect,3,1,1
%>
 |
<%
end if
%>
| |