原创投稿 |　常用软件
您的位置：网站首页 > 源码分享 > ASP程序 > 正文

简易ASP注册系统ASP技巧

文章作者：三亚上门维修电脑 发布日期：2012/2/11 9:01:18
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<html>
<head><title>asp+注册</title>
<link rel="stylesheet" type="text/CSS" href="main.css">
<Script Language="C#" RunAt=Server>
void btnSubmit_Click(Object Src,EventArgs E)
{
     if(Page.IsValid)
     {
    String strSQL;
    strSQL="INSERT INTO tblUserInfo VALUES(@UserName,@PassWord,@Email)";
    
    SQLConnection cnn=new SQLConnection("Server=niu;UID=sa;PWD=;DataBase=aspx");
    SQLCommand cmm=new SQLCommand(strSQL,cnn);
    
    cmm.Parameters.Add(new SQLParameter("@UserName",SQLDataType.VarChar,20));
    cmm.Parameters["@UserName"].Value=txtName.Text;
    
    cmm.Parameters.Add(new SQLParameter("@PassWord",SQLDataType.VarChar,20));
    cmm.Parameters["@PassWord"].Value=txtName.Text;
    
    cmm.Parameters.Add(new SQLParameter("@Email",SQLDataType.VarChar,60));
    cmm.Parameters["@Email"].Value=txtName.Text;

    cmm.ActiveConnection.Open();
    try
    {
      cmm.Execute();
      cmm.ActiveConnection.Close();
      Page.Navigate("result.aspx");
    }
    catch
    {
      lblMsg.Style["color"]="red";
      lblMsg.Text="插入数据出错";
    }
     }

}
</Script>
</head>
<body>
<h2 align="center">ASP+注册系统</h2>
<ASP:Label ID="lblMsg" RunAt=Server/>
<form RunAt=Server>
  <table bgcolor="#eeeeee" cellpadding="10" align="center">
   <tr>
      <td>姓名：</td>
      <td>
        <ASP:TextBox ID="txtName" MaxLength="20" Class="mytext" RunAt=Server/>
      </td>
      <td>
        <ASP:RequiredFieldValidator ID="rfvName"
             ControlToValidate="txtName"
         Display="Dynamic"
         InitalValue=""
         ErrorMessage="*"
         RunAt=Server>
        </ASP:RequiredFieldValidator>
      </td>
    </tr>
    <tr>
      <td>密码：</td>
      <td>
    <ASP:TextBox ID="txtPassWord" TextMode="PassWord" MaxLength="20" Class="mytext" RunAt=Server/>
      </td>
      <td>
    <ASP:RequiredFieldValidator ID="rfvPassWord"
         ControlToValidate="txtPassWord"
         Display="Dynamic"
         InitialValue=""
         ErrorMessage="*"
         RunAt=Server>
    </ASP:RequiredFieldValidator>
      </td>
    </tr>
    <tr>
      <td>确认密码：</td>
      <td>
        <ASP:TextBox ID="txtRePassWord" TextMode="PassWord" MaxLength="20" Class="mytext" RunAt=Server/>
      </td>
      <td>
        <ASP:RequiredFieldValidator ID="rfvRePassWord"
         ControlToValidate="txtRePassWord"
         Display="Dynamic"
         InitialValue=""
         ErrorMessage="*"
         RunAt=Server>
    </ASP:RequiredFieldValidator>
    <ASP:CompareValidator ID="cvRePassWord"
         ControlToValidate="txtRePassWord" ControlToCompare="txtPassWord"
         Display="Dynamic"
         ErrorMessage="密码确认错，请注意字母大小写！"
         Runat=Server>
    </ASP:CompareValidator>
      </td>
    </tr>
    <tr>
      <td>电子邮件：</td>
      <td>
        <ASP:TextBox ID="txtEmail" MaxLength="60" Class="mytext" RunAt=Server/>
      </td>
      <td>
        <ASP:RequiredFieldValidator ID="rvfEmail"
         ControlToValidate="txtEmail"
         InitialValue=""
         Display="Dynamic"
         ErrorMessage="*"
         RunAt=Server>
    </ASP:RequiredFieldValidator>
    <ASP:RegularExPRessionValidator ID="revEmail"
             ControlToValidate="txtEmail"
             Display="Dynamic"
             ErrorMessage="无效电子邮件地址！"
         ValidationExpression="^[\w-]+@[\w-]+\.(com|net|org|edu|mil)$"
             RunAt=Server>
        </ASP:RegularExpressionValidator>
      </td>
    </tr>
    <tr>
      <td colspan="3" align="center">
        <ASP:Button ID="btnSubmit" OnClick="btnSubmit_Click" Text="提交" Class="mybtn" RunAt=Server/>      
      </td>
   </tr>
  </table>
</form>
</body>
</html>

注意：联系我时，请一定说明是从【S】看到的信息，谢谢。

编辑：
联系电话：
联系 QQ：
打电话给我、或者加QQ好友时，请一定说明来自（三亚上门维修电脑）谢谢您！
三亚上门维修电脑

上一篇：对数据库连接问题的一点总结ASP技巧
下一篇：页边距的设定技巧HTMLASP技巧