ASP.NET简单登录注册实例

时间：2024-01-16 20:03:26
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %>

<!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>

       <table>

        <tr>

            <td> <asp:Label ID="Label1" runat="server" Text="用户名:"></asp:Label> </td>

            <td> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>

        </tr>

          <tr>

            <td> <asp:Label ID="Label2" runat="server" Text="密码:"></asp:Label> </td>

            <td> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>

        </tr>

         <tr>

            <td><asp:Button ID="Button2" runat="server" Text="登录" onclick="Button2_Click" /> </asp:Label> </td>

            <td> <asp:Button ID="Button1" runat="server" Text="注册" onclick="Button1_Click" /> </asp:TextBox></td>

        </tr>

       </table>

    </div>

    </form>

</body>

</html>
using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

namespace WebApplication1

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        //登录

        protected void Button2_Click(object sender, EventArgs e)

        {

            string name = TextBox1.Text;

            string pwd = TextBox2.Text;

            if (name!=null||pwd!=null)

            {

                string sql = "select count(0) from student where stuName=@a and stuNo=@b";//获取数据中的信息

                SqlParameter p1 = new SqlParameter("@a",name);

                SqlParameter p2 = new SqlParameter("@b",pwd);

                //连接数据库

                string connStr = "server=DESKTOP-QQGOIKH;uid=sa;pwd=123;database=stuDB";

                SqlConnection conn = new SqlConnection(connStr);

                conn.Open();

                SqlCommand cmd = new SqlCommand(sql,conn);

                cmd.Parameters.Add(p1);

                cmd.Parameters.Add(p2);

                object obj = cmd.ExecuteScalar();

                conn.Close();

                int i = (int)obj;

                if (i>)

                {

                    Response.Redirect("WebForm2.aspx");

                }

                else

                {

                    Response.Write("登录失败");

                }

            }

            else

            {

                return;

            }

        }

        //注册

        protected void Button1_Click(object sender, EventArgs e)

        {

            Response.Redirect("WebForm3.aspx");

        }

    }

}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm3.aspx.cs" Inherits="WebApplication1.WebForm3" %>

<!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>

    <table>

        <tr>

            <td><asp:Label ID="Label1" runat="server" Text="用户名:"></asp:Label> </td>

            <td> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>

        </tr>

        <tr>

            <td><asp:Label ID="Label2" runat="server" Text="密码:"></asp:Label> </td>

            <td><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </td>

        </tr>

        <tr>

            <td> <asp:Button ID="Button1" runat="server" Text="注册" onclick="Button1_Click" /> </td>

            <td> <asp:Button ID="Button2" runat="server" Text="返回" onclick="Button2_Click" /> </td>

        </tr>

    </table>

    </div>

    </form>

</body>

</html>
using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

namespace WebApplication1

{

    public partial class WebForm3 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        //注册

        protected void Button1_Click(object sender, EventArgs e)

        {

            string name = TextBox1.Text;

            string pwd = TextBox2.Text;

            if (name!=null||pwd!=null)

            {

                string sql = "insert into enter values(@a,@b)";

                SqlParameter[] sp = new SqlParameter[];

                sp[] = new SqlParameter("@a",TextBox1.Text);

                sp[] = new SqlParameter("@b",TextBox2.Text);

                SqlConnection conn = new SqlConnection("server=STER-PC;uid=sa;pwd=123;database=t2");

                conn.Open();

                SqlCommand comm = new SqlCommand(sql,conn);

                comm.Parameters.AddRange(sp);//添加数组

                int i = comm.ExecuteNonQuery();

                conn.Close();

                if (i>)

                {

                    Response.Write("注册成功");

                }

                else

                {

                    Response.Write("注册失败");

                }

            }

            else

            {

                Response.Write("请填写内容");

            }

        }

        //返回

        protected void Button2_Click(object sender, EventArgs e)

        {

            Response.Redirect("WebForm1.aspx");

        }

    }

}

相关文章