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]
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5