asp登陆例子，asp,mssql,登陆

最新推荐文章于 2021-02-23 00:33:51 发布

limon758

最新推荐文章于 2021-02-23 00:33:51 发布

阅读量225

点赞数

分类专栏： c#(asp.net) 文章标签： ASP ASP.net Web UI SQL Server

c#(asp.net) 专栏收录该内容

134 篇文章 0 订阅

订阅专栏

<%@ 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="关　闭" οnclick="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>

------------------------------------------------------------------------------------

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" />
  <!--ｖａｌｕｅ为１表示连接的数据库是ＳＱＬ，２表示ｏｒａｃｌｅ-->
     <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