使用服务器端数据验证控件的综合实例

最新推荐文章于 2022-03-11 17:33:42 发布

love3e4520

最新推荐文章于 2022-03-11 17:33:42 发布

阅读量754

点赞数

分类专栏： vs.net2005 文章标签：服务器 textbox server button asp integer

本文链接：https://blog.csdn.net/love3e4520/article/details/1484020

版权

vs.net2005 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>验证控件的综合实例</title>
</head>
<body>
    <form id="form1" runat="server">

        <table style="width: 800px; height: 369px"><tr><td style="width: 253px; height: 8px;" align="center">请填写注册信息</td><td style="width: 2px; height: 8px;" align="left"></td></tr><tr><td style="width: 253px; height: 2px;" align="left">用户名：<asp:TextBox ID="TextBox1" runat="server" Height="16px" Width="110px"></asp:TextBox></td><td style="width: 2px; height: 2px;" align="left"><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                        ErrorMessage="用户名不能为空！" Height="23px" Width="163px"></asp:RequiredFieldValidator></td></tr><tr><td style="width: 253px; height: 1px;" align="left">登陆密码：<asp:TextBox ID="TextBox2" runat="server" TextMode="Password" Width="110px"></asp:TextBox></td><td style="width: 2px; height: 1px;" align="left"><asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2"
                        ErrorMessage="登陆密码不能为空！" Height="24px" Width="189px"></asp:RequiredFieldValidator></td></tr><tr><td style="width: 253px; height: 1px;" align="left">确认密码：<asp:TextBox ID="TextBox3" runat="server" TextMode="Password" Width="110px"></asp:TextBox><br /><asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="TextBox2"
                        ControlToValidate="TextBox3" ErrorMessage="密码不一致！" Height="20px" Width="110px"></asp:CompareValidator></td><td style="width: 2px; height: 1px;" align="left"><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3"
                        ErrorMessage="确认密码不能为空！" Height="36px" Width="189px"></asp:RequiredFieldValidator></td></tr><tr><td style="width: 253px; height: 3px;" align="left">学    号：<asp:TextBox ID="TextBox4" runat="server" Width="110px"></asp:TextBox><br /><asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="TextBox4"
                        ErrorMessage="学号的有效范围是［1,100］！" MaximumValue="100" MinimumValue="1" Type="Integer" Width="212px"></asp:RangeValidator></td><td style="width: 2px; height: 3px;" align="left"><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox4"
                        ErrorMessage="学号不能为空！" Height="36px" Width="184px"></asp:RequiredFieldValidator></td></tr><tr><td style="width: 253px;" align="left">Email：<asp:TextBox ID="TextBox5" runat="server" Height="21px" Width="200px"></asp:TextBox><br /><asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox5"
                        ErrorMessage="Email格式错误！" ValidationExpression=".{1,}@.{3,}" Width="136px"></asp:RegularExpressionValidator></td><td style="width: 2px;" align="left"><asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox5"
                        ErrorMessage="Email不能为空！" Height="35px" Width="187px"></asp:RequiredFieldValidator></td></tr><tr><td style="width: 253px" align="center"><asp:Button ID="Button1" runat="server" Height="27px" Text="提交" Width="58px" OnClick="Button1_Click" /></td><td style="width: 2px" align="left"></td></tr><tr><td style="width: 253px; height: 12px;" align="left"><asp:Label ID="Label1" runat="server" Height="19px" Width="170px"></asp:Label></td><td style="width: 2px; height: 12px;" align="left"><asp:ValidationSummary ID="ValidationSummary1" runat="server" HeaderText="验证结果："
                        Height="47px" Width="180px" /> </td></tr></table>
    </form>
</body>
</html>

public partial class yanzheng : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection myConnection = new SqlConnection("server=localhost;uid=sa;pwd=860712;database=Aspnet");
        string strSQL = "INSERT INTO Ex0501 (用户名,密码,学号,电子邮件) VALUES ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "')";
        try
        {
            myConnection.Open();
            SqlCommand mySqlCommand = new SqlCommand(strSQL, myConnection);
            mySqlCommand.ExecuteNonQuery();
            Label1.Text = "注册成功！";
        }
        catch
        {
            Label1.Text = "数据库连接失败！";
        }
        finally
        {
            myConnection.Close();
        }
    }
}