<% if Session("UserName")="" then %>
You are not authorised User. Please
login again
<% else %>
Welcome
<%=Session("UserName")%>
Home
||
Add Work
||
Edit / Remove Events
||
Logout
Client Name
Last Work Done
To Be Done by
Pending With
Date
User
<% today=date() 'Response.Write today 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.Mode=3 Connect.open set rs = Server.CreateObject("ADODB.Recordset") Sql="select * from emp"' where uname='" & Session("UserName") & "' Order By date ASC" on error resume next rs.Open SQL,Connect,3,1,1 while not rs.EOF response.write("
" & rs("client") & "
") 'response.write("
Delete
") response.write("
" & rs("last_wk_done") & "
") response.write("
" & rs("to_be_done") & "
") response.write("
" & rs("pendingwith") & "
") response.write("
" & rs("date") & "
") response.write("
" & rs("uname") & "
") %> <%rs.Movenext wend %>
<% end if 'for Session %>