复制代码 代码如下:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Registe.aspx.cs" Inherits="CSDN博客.Registe" %>
.zhuyi
{
color:Red;
font-size:small;
}
#pwd-strong {
float: left;
margin: 0px;
padding: 0px;
list-style: none;
background-image: url(images/pwdstrong.gif);
background-repeat: no-repeat;
}
#pwd-strong li {
float: left;
padding: 0px;
color: #ccc;
font-size: 11px;
width: 64px;
height: 10px;
text-align: center;
padding-top: 9px;
}
.pwds3 {
background-position: -20px -70px;
}
.pwds2 {
background-position: -20px -44px;
}
.pwds1 {
background-position: -20px -18px;
}
#pwd-strong li.currs {
color: #000;
}
#head
{
margin:0;
}
#head a:hover
{
color:Red;
}
.ahead
{
color:black;
font-size:small;
text-decoration:none;
}
#lefthead
{
float:left;
margin:0;
}
#righthead
{
float:right;
margin:0;
}
#body
{
position:absolute;
width:900px;
height:700px;
left:230px;
top:50px;
}
#picture
{
float:left;
}
#xinxi
{
border:1px solid pink;
width:850px;
height:440px;
position:absolute;
left:20px;
top:50px
}
#biaoti
{
position:absolute;
left:1px;
top:10px;
}
#xian
{
position:absolute;
left:20px;
top:50px;
}
#table
{
position:absolute;
left:50px;
top:90px;
}
#footer
{
position:absolute;
left:430px;
top:560px;
}
.buttom
{
margin:0px;
font-size:small;
}
.abuttom
{
text-decoration:none;
color:Black;
}
#footer a:hover
{
color:Blue;
}
img
{
border:0px;
}
------------激活验证
复制代码 代码如下:
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;
namespace CSDN博客
{
public partial class cheng : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//取出参数id
int id = Convert.ToInt32(Request["id"]);
string activeCode = Request["activecode"].ToString();
//2判断id为id的记录是否存在
//连接数据库
string conStr = "data source=LOVE-PC\SQLEXPRESSPC;initial catalog=Blogs;user id=sa;password=admin";
int number;
using (SqlConnection con = new SqlConnection(conStr))
{
string sql = "select count(*) from T_User where Id=@id";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
cmd.Parameters.AddWithValue("@id", id);
number = Convert.ToInt32(cmd.ExecuteScalar());
}
}
if (number > 0)
{
//如果该用户存在取出ActiveCode字段进行比较。如果一样，把Active字段修改为true
//连接数据库
string AC;
using (SqlConnection con = new SqlConnection(conStr))
{
string sql = "select ActiveCode from T_User where Id=@id";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
cmd.Parameters.AddWithValue("@id", id);
AC = cmd.ExecuteScalar().ToString(); ;
}
}
if (activeCode == AC)
{
Response.Write("激活成功!返回登录");
using (SqlConnection con = new SqlConnection(conStr))
{
string sql = "update T_User set Active=1 where Id=@id";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
cmd.Parameters.AddWithValue("@id", id);
number = Convert.ToInt32(cmd.ExecuteScalar());
}
}
}
else
{
Response.Write("用户已存在，但是激活码错误！");
}
}
else
{
Response.Write("用户不存在，还没注册成功！");
}
}
}
}
实现如下效果：
