Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keep a log of visitors 2

Status
Not open for further replies.
Cooperdam

Cooperdam

MIS
Oct 7, 2009
65
US
HI I have a login page, and was thinking to keep a log of visitors, or the time they came in. Should this be done here in this code? I would need a table as well.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="RReports.Login" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
<html xmlns=" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>

<table style="width:100%;">
<tr>
<td width="60%">
 </td>
<td width="20%">
 </td>
<td width="20%">
 </td>
</tr>
<tr>
<td>
 </td>
<td style="text-align: right">
 </td>
<td>
<asp:Label ID="lblMessage" runat="server" ForeColor="Red"
style="font-family: Arial, Helvetica, sans-serif; font-size: small"></asp:Label>
</td>
</tr>
<tr>
<td>
 </td>
<td style="text-align: right">
<asp:Label ID="Label1" runat="server"
style="font-family: Arial, Helvetica, sans-serif; font-size: small;"
Text="UserName : "></asp:Label>
</td>
<td>
<asp:TextBox ID="txtUserName" runat="server"
style="font-family: Arial, Helvetica, sans-serif" Text=" "></asp:TextBox>
</td>
</tr>
<tr>
<td>
 </td>
<td style="text-align: right">
<asp:Label ID="Label2" runat="server"
style="text-align: right; font-family: Arial, Helvetica, sans-serif; font-size: small;"
Text="Password : "></asp:Label>
</td>
<td>
<asp:TextBox ID="txtPassword" runat="server"
style="font-family: Arial, Helvetica, sans-serif" Text=" " TextMode="Password"></asp:TextBox>
</td>
</tr>
<tr>
<td>
 </td>
<td>
 </td>
<td>
<asp:Button ID="btnLogin" runat="server" onclick="btnLogin_Click"
style="font-family: Arial, Helvetica, sans-serif" Text="Login" />
</td>
</tr>
<tr>
<td>
 </td>
<td>
 </td>
<td>
 </td>
</tr>
</table>

</div>
</form>
</body>
</html>
 
Sort by date Sort by votes
Thank you JBenson! I am not sure how to do this type of thing. this is my code-behind:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;
using System.Xml;
using RReports.Helpers;

namespace RReports
{
public partial class Login : System.Web.UI.Page
{
const string XML_CONFIG_FILE = "reports.xml";

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ClearSession();
}

// Compilation Directive
// This will by-pass the authentication when DEV flag is added to Conditional Compilation Symbols
// If not, it will ask for login as usual
#if DEV
txtPassword.Text = "test";
btnLogin_Click(null, null);
#endif
}

private void ClearSession()
{
// Clear all Session data
Session.Clear();
}

protected void btnLogin_Click(object sender, EventArgs e)
{
ClearSession();
lblMessage.Text = "";

// Perform Login based on the entered UserName and Password
string sql = "Select * from Users where UserName = '" + txtUserName.Text.Replace("'", "") + "' and Password = '" + txtPassword.Text.Replace("'", "") + "'";
DataSet ds = Lib.GetResults(sql, ConnectionHelper.GetSecurityDatabaseConnection());

if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count == 1)
{
Session["UserName"] = txtUserName.Text.Trim();
Response.Redirect("DashBoard.aspx");
}
else
{
lblMessage.Text = "Invalid UserName/Password.";
}
}
else
{
lblMessage.Text = "Invalid UserName/Password.";
}
}
else
{
lblMessage.Text = "Invalid UserName/Password.";
}

}
}

}
 
Upvote 0 Downvote
Code: 
                    if (ds.Tables[0].Rows.Count == 1)
                    {
                        Session["UserName"] = txtUserName.Text.Trim();
                        Response.Redirect("DashBoard.aspx");
                    }
This section of your code assumes a login is correct, so you'll just need to add an insert statement here to enter the details into your database (I'll assume your "Lib" object has an easy way of performing an insert for you).

However, if all you are doing is auditing the fact that a user logged into the system, it may be much easier to just use a stored procedure that not only returns the results of checking the users credentials, but performs the audit as well.

I'm also hoping that you aren't storing the passwords in the database in plain text...

Mark,

Darlington Web Design
Experts, Information, Ideas & Knowledge
ASP.NET Tips & Tricks
 
Upvote 0 Downvote
Mark, yes we are. What can we do instead? I am new to this.
The users are all our customers but they are not coming in via a VPN. But the server is a standalone getting the data refreshed every night.
 
Upvote 0 Downvote
Passwords should be created using a one-way hash algorithum. I would do this through the .NET framework. There are many examples on line.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AhmedAzizBarbary
  • Locked
  • Question
How to pass list of checkboxes not checked on page model razor page?
Replies
0
Views
443
AhmedAzizBarbary
AhmedAzizBarbary
AhmedAzizBarbary
  • Locked
  • Question
How to read data response body after success login razor page ?
Replies
0
Views
411
AhmedAzizBarbary
AhmedAzizBarbary
Makumbi256
  • Locked
  • Question
How to make days vertical and grid view editable using asp.net vb
Replies
0
Views
292
Makumbi256
Makumbi256
weberm
  • Locked
  • Question
How do I make a page with multiple AJAX custom controls?
Replies
2
Views
374
weberm
weberm
a6green
  • Locked
  • Question
How to configure AT&T / Avaya Definity G3 incoming ISDN trunk
Replies
2
Views
406
a6green
a6green

Part and Inventory Search

Sponsor

Back
Top