WEB开发网
开发学院WEB开发ASP 简易ASP+注册系统 阅读

简易ASP+注册系统

 2000-10-24 10:12:00 来源:WEB开发网   
核心提示:<%@ Page Language="C#" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.SQL" %><html&
<%@ 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>

Tags:简易 ASP 注册

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接