aspログイン例,asp,mssql,ログイン
9985 ワード
login.aspxファイル
------------------------------------------------------------------------------------
login.aspx.csファイル
------------------------------------------------------------------------------------
index.aspx
---------------------------------------------------------------------------
index.aspx.cs
-----------------------------------------------------------------------------------
web.configファイル
黒い髪http://heisetoufa.iteye.com
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="login.aspx.cs" Inherits="login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title> </title>
</head>
<body>
<form id="form1" runat="server">
<div valign="middle">
<table valign="center" align="center" border="1" cellpadding="0" cellspacing="0" bordercolorlight="#003366" bordercolordark="#ffffff">
<tr id="addData_TR" class="STYLE1" >
<td colspan="2" align="center">
</td>
</tr>
<tr class="STYLE1">
<td> :</td>
<td><input name="userName" type="text" id="Txt_LoginName" runat="server"/>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="Txt_LoginName"
ErrorMessage=" !">*</asp:RequiredFieldValidator></td>
</tr>
<tr class="STYLE1">
<td>
:</td>
<td><input name="psw" type="password" id="Txt_Password" runat="server" style="width: 149px"/>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="Txt_Password"
ErrorMessage=" !">*</asp:RequiredFieldValidator></td>
</tr>
<tr>
<td colspan="2" align="center" style="height: 26px">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text=" " />
<input type="button" value=" " onclick="window.opener=null;window.close();" />
</td>
</tr>
</table>
</div>
</form>
<script type="text/javascript">
var oUserId = document.getElementById("Txt_LoginName");
var oPwd = document.getElementById("Txt_Password");
window.onload = function()
{
oUserId.focus();
oUserId.onkeydown = function ()
{
if(event.keyCode == 13 ) oPwd.focus();
}
}
</script>
</body>
</html>
------------------------------------------------------------------------------------
login.aspx.csファイル
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class login : System.Web.UI.Page
{
protected SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["Conn"]);
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql = "select * from person where name='" + this.Txt_LoginName.Value + "'";
SqlDataAdapter cmd = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
cmd.Fill(dt);
if (dt.Rows.Count == 1)
{
//Session["name"] = dt.Rows[0]["user_name"].ToString();
Session["user_id"] = dt.Rows[0]["name"].ToString();
Session["pwd"] = dt.Rows[0]["password"].ToString();
//Session["flg"] = dt.Rows[0]["flg"].ToString();
if (this.Txt_Password.Value == dt.Rows[0]["password"].ToString().Trim())
{
System.Web.Security.FormsAuthentication.RedirectFromLoginPage(this.Txt_LoginName.Value, false);
this.Response.Redirect("index.aspx");
}
}
if (dt.Rows.Count == 0)
{
this.RegisterStartupScript("T", "<script language=javascript>alert(' , !')</script>");
}
else if (dt.Rows.Count > 1)
{
this.RegisterStartupScript("T", "<script language=javascript>alert(' !')</script>");
}
}
}
------------------------------------------------------------------------------------
index.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="index" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title> </title>
</head>
<body>
<form id="form1" runat="server">
<div>
!
</div>
</form>
</body>
</html>
---------------------------------------------------------------------------
index.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class index : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
-----------------------------------------------------------------------------------
web.configファイル
<?xml version="1.0"?><!--
: ,
Web 。 Visual Studio
“ ”->“Asp.Net ” 。
machine.config.comments ,
\Windows\Microsoft.Net\Framework\v2.x\Config
--><configuration>
<appSettings>
<add key="Conn" value="Data Source=localhost;Initial Catalog=dzjc_2005;User ID=sa;Password= " />
<add key="DataBaseType" value="1" />
<!--value 1 SQL,2 oracle-->
<add key="CrystalImageCleaner-AutoStart" value="true" />
<add key="CrystalImageCleaner-Sleep" value="60000" />
<add key="CrystalImageCleaner-Age" value="120000" />
</appSettings>
<system.web>
<!--
compilation debug="true"
。
,
true。
-->
<compilation debug="true">
<assemblies>
<add assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/><add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies></compilation>
<authorization>
<deny users="?"/>
</authorization>
<authentication mode="Forms">
<forms loginUrl="login.aspx" name=".App" timeout="7200"></forms>
</authentication>
<!--
<authentication> ASP.NET
,
。
-->
<!--<authentication mode="Windows"/>
,
<customErrors> 。 ,
html
。
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
<httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></httpHandlers></system.web>
<location path="index">
<system.web>
<authorization>
<allow users="*"/>
</authorization>
</system.web>
</location>
</configuration>
黒い髪http://heisetoufa.iteye.com