WebForm写一个简单的登录

首先写一个简单的登录界面

Login.aspx

<form id="form1" runat="server">
        <asp:Label ID="Label1" runat="server" AssociatedControlID="UserName">用户名</asp:Label>
        <asp:TextBox runat="server" ID="UserName" />
        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="UserName" CssClass="field-validation-error" ErrorMessage="用户名字段是必填字段。" />
        <br />
        <asp:Label ID="Label2" runat="server" AssociatedControlID="Password">密码</asp:Label>
        <asp:TextBox runat="server" ID="Password" TextMode="Password" />
        <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="Password" CssClass="field-validation-error" ErrorMessage="密码字段是必填字段。" />
        <br />
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="登录" />
    </form>

然后就是在登录按钮的点击事件上写登录验证

Login.aspx.cs

 /*按钮点击事件*/
        protected void Button1_Click(object sender, EventArgs e)
        {
            string message = "用户名或密码输入有误！";
            string username = UserName.Text;
            password = Password.Text;

           string strcon = ConfigurationManager.AppSettings["conn"].ToString();    //里面的conn是在web.config中配置的key

            string sql = "select * from test where name = '"+username+"' and age = '"+password+"';  //字符串类型的数据需要加上单引号
            using (MySqlConnection con = new MySqlConnection(strcon))
            {

                MySqlCommand cmd = new MySqlCommand(sql, con);

                con.Open();

                MySqlDataReader dr = cmd.ExecuteReader();

                if (dr.HasRows)
                {
                    Response.Redirect("MySql_Demo.aspx");//登录成功后跳转的页面
                }
                else {
                    Response.Write("<script>alert(\"" + message + "\")</script>");  //提示用户输入有误
                }
                con.Close();

            }
        }

配置Web.config

<configuration>
 
  <appSettings>
    <add key="conn" value="server=服务器; database=数据库; uid=用户名; password=密码;"/>

  </appSettings>

 
</configuration>