Torna al Thread
[CODE]
<%@ Page Language="c#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ import Namespace="System.Security.Principal" %>
<script runat="server">
void Page_Load(Object o, EventArgs e) {
if (Request["ReturnUrl"]!=null && User.Identity.Name!="" )
Response.Redirect ("Error.aspx");
}
void DoLogin(Object o, EventArgs e) {
string strConn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Request.MapPath("db/utenti.mdb");
OleDbConnection objConn = new OleDbConnection(strConn);
objConn.Open();
string strsql= "SELECT * FROM Utenti where " +
"nome='"+user.Value+"' and password='"+pass.Value+"'";
OleDbCommand objCommand = new OleDbCommand(strsql, objConn);
OleDbDataReader objDataReader;
objDataReader=objCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (objDataReader.Read()) {
if (user.Value==objDataReader["nome"].ToString() && pass.Value==objDataReader["password"].ToString()) {
string nome=user.Value+":"+objDataReader["role"];
FormsAuthentication.RedirectFromLoginPage(nome,false);
}
}
else
errore.InnerHtml="<b>User Name e Password non corretti!</b>";
objConn.Close();
}
</script>
<html>
<head>
<meta name="Language" content="IT">
<link rel="stylesheet" href="style.css" type="text/css">
<title>::: Utilizzo dei gruppi in Asp.Net - Login :::</title>
<script>
function focus() {
document.forms[0].user.focus();
}
</script>
</head>
<body onload="focus()">
<form runat="server">
<table border="0" cellpadding="1" cellspacing="1" width="440" bgcolor="#000000" align="center"><tr><td>
<table cellspacing="1" cellpadding="0" width="100%" bgcolor="#fffEaE"><tr>
<td align="middle" colspan="2">
<h4 align="center">Inserisci i dati per l'identificazione</h4>
</td>
</tr><tr>
<td align="right">User Name:</td>
<td align="left"><input id="user" type="text" runat="server" /></td>
</tr><tr>
<td align="right">Password:</td>
<td align="left"><input id="pass" type="password" runat="server" /></td>
</tr><tr>
<td align="middle" colspan="2"><input type="submit" value="Entra..." runat="server" onserverclick="DoLogin" />
<p/>
<div id="errore" runat="server" />
<table border="1" cellpadding="0" cellspacing="0" bordercolor="#0033cc" width="100%">
<tr><th>User name</th><th>Password</th><th>Role</th></tr>
<tr><td>Andrea</td><td>1974</td><td>Admin</td></tr>
<tr><td>Responsabile</td><td>0000</td><td>Manager</td></tr>
<tr><td>Utente1</td><td>1111</td><td>Utente</td></tr>
<tr><td>Utente2</td><td>2222</td><td>Utente</td></tr>
<tr><td>Utente3</td><td>3333</td><td>Utente</td></tr>
</table>
<p align="center">
<a href="default.aspx">Torna alla pagina principale</a>
</p>
</td></tr></table>
</td></tr></table>
</form>
</body>
</html>[/CODE]