点注册的时候CS里面的代码 private void RRegister_Click(object sender, System.EventArgs e) { //创建数据库的连接 SqlConnection myConnection = new SqlConnection(ConnectionString); //判断此用户是否存在 string cmdText = "select UserName from Users where UserName = '"+RUsersName.Text+"'"; SqlCommand myCommand = new SqlCommand(cmdText,myConnection); myConnection.Open(); SqlDataReader dr=myCommand.ExecuteReader();if(dr.Read()) { Response.Write("<script>alert(\"此用户名已经存在!\")</script>");//存在就提示用户 } else { dr.Close();//判断用户的Email地址是否重复 string cmdText3 = "select UserID from Users where Email = '"+REmail.Text+"'"; SqlCommand myCommand3 = new SqlCommand(cmdText3,myConnection); SqlDataReader dr3=myCommand3.ExecuteReader(); if(dr3.Read()) { Response.Write("<script>alert(\"此Email已经存在!\")</script>");//存在就提示用户 } else { dr3.Close();//给出当前注册用户的ID
string uid = "select max(UserID) from Users"; SqlCommand myCommand2 = new SqlCommand(uid,myConnection); int id = (int)myCommand2.ExecuteScalar(); id = id + 1;
我们的这些都是在HTML里面用WEB控件控制的,应该是没问题的撒,不知道为什么就不行?
用的就是这些控件RequiredFieldValidator,RegularExpressionValidator
<%@ Page language="c#" Codebehind="Register.aspx.cs" AutoEventWireup="false" Inherits="Liuyanban1.Register" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>zhuce</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:label id="TitleZhuCe" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 16px" runat="server" Font-Size="Large">新用户注册</asp:label>
<asp:label id="Labelattention" style="Z-INDEX: 102; LEFT: 16px; POSITION: absolute; TOP: 64px" runat="server" ForeColor="Red">注意事项:以下带*号的必须填写</asp:label>
<asp:label id="LRUsersName" style="Z-INDEX: 103; LEFT: 147px; POSITION: absolute; TOP: 110px" runat="server" Font-Size="Medium" ForeColor="Black">用户名</asp:label>
<asp:label id="LRPassword" style="Z-INDEX: 104; LEFT: 154px; POSITION: absolute; TOP: 190px" runat="server" Font-Size="Medium">密 码</asp:label>
<asp:label id="LRPasswordCfm" style="Z-INDEX: 105; LEFT: 128px; POSITION: absolute; TOP: 264px" runat="server" Font-Size="Medium">确认密码</asp:label>
<asp:label id="LREmail" style="Z-INDEX: 106; LEFT: 120px; POSITION: absolute; TOP: 334px" runat="server" Font-Size="Medium">Email地址</asp:label>
<asp:textbox id="RUsersName" style="Z-INDEX: 107; LEFT: 216px; POSITION: absolute; TOP: 104px" runat="server" BorderColor="Black" BorderStyle="Solid" Width="152px"></asp:textbox>
<asp:textbox id="RPassword" style="Z-INDEX: 108; LEFT: 216px; POSITION: absolute; TOP: 184px" runat="server" BorderStyle="Solid" Width="152px" TextMode="Password"></asp:textbox><
asp:textbox id="RPasswordCfm" style="Z-INDEX: 109; LEFT: 216px; POSITION: absolute; TOP: 256px" runat="server" BorderColor="Black" BorderStyle="Solid" Width="152px" TextMode="Password"></asp:textbox>
<asp:textbox id="REmail" style="Z-INDEX: 110; LEFT: 216px; POSITION: absolute; TOP: 328px" runat="server" BorderColor="Black" BorderStyle="Solid" Width="152px"></asp:textbox>
<asp:label id="Label1" style="Z-INDEX: 111; LEFT: 200px; POSITION: absolute; TOP: 104px" runat="server" ForeColor="Red">*</asp:label>
<asp:label id="Label2" style="Z-INDEX: 112; LEFT: 200px; POSITION: absolute; TOP: 187px" runat="server" ForeColor="Red">*</asp:label>
<asp:label id="Label3" style="Z-INDEX: 113; LEFT: 200px; POSITION: absolute; TOP: 258px" runat="server" ForeColor="Red">*</asp:label>
<asp:label id="Label4" style="Z-INDEX: 114; LEFT: 200px; POSITION: absolute; TOP: 327px" runat="server" ForeColor="Red">*</asp:label>
<asp:requiredfieldvalidator id="RequiredFieldValidator1" style="Z-INDEX: 115; LEFT: 432px; POSITION: absolute; TOP: 104px" runat="server" ErrorMessage="用户名必须填写!" ControlToValidate="RUsersName" Display="Dynamic"></asp:requiredfieldvalidator>
<asp:requiredfieldvalidator id="RequiredFieldValidator2" style="Z-INDEX: 116; LEFT: 376px; POSITION: absolute; TOP: 192px" runat="server" ErrorMessage="用户密码必须填写!" ControlToValidate="RPassword" Display="Dynamic"></asp:requiredfieldvalidator>
<asp:requiredfieldvalidator id="RequiredFieldValidator3" style="Z-INDEX: 117; LEFT: 376px; POSITION: absolute; TOP: 264px" runat="server" ErrorMessage="确认密码必须填写!" ControlToValidate="RPasswordCfm" Display="Dynamic"></asp:requiredfieldvalidator>
<asp:requiredfieldvalidator id="RequiredFieldValidator4" style="Z-INDEX: 118; LEFT: 376px; POSITION: absolute; TOP: 332px" runat="server" ErrorMessage="Email地址必须填写!" ControlToValidate="REmail" Display="Dynamic"></asp:requiredfieldvalidator>
<asp:regularexpressionvalidator id="RegularExpressionValidator1" style="Z-INDEX: 119; LEFT: 216px; POSITION: absolute; TOP: 136px" runat="server" ErrorMessage="用户名首字符必须是字母,其后只能含有字母、数字和下划线!" ControlToValidate="RUsersName" Display="Dynamic" ValidationExpression="([A-Za-z]{1})\w{1,19}"></asp:regularexpressionvalidator>
<asp:comparevalidator id="CompareValidator1" style="Z-INDEX: 120; LEFT: 216px; POSITION: absolute; TOP: 285px" runat="server" ErrorMessage="两次输入密码必须一致!" ControlToValidate="RPasswordCfm" Display="Dynamic" ControlToCompare="RPassword"></asp:comparevalidator>
<asp:regularexpressionvalidator id="RegularExpressionValidator3" style="Z-INDEX: 121; LEFT: 216px; POSITION: absolute; TOP: 355px" runat="server" ErrorMessage="请输入正确的Email地址!" ControlToValidate="REmail" Display="Dynamic" ValidationExpression="\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:regularexpressionvalidator>
<asp:button id="RRegister" style="Z-INDEX: 122; LEFT: 312px; POSITION: absolute; TOP: 400px" runat="server" Font-Size="Small" BorderColor="#E0E0E0" Width="56px" Text="注册" BackColor="Gainsboro"></asp:button>
<asp:regularexpressionvalidator id="RegularExpressionValidator2" style="Z-INDEX: 123; LEFT: 216px; POSITION: absolute; TOP: 214px" runat="server" Width="284px" ErrorMessage="密码最小长度为 8 位!最大长度20位!" ControlToValidate="RPassword" Display="Dynamic" ValidationExpression="\w{8,20}"></asp:regularexpressionvalidator>
<asp:button id="RCheck" style="Z-INDEX: 124; LEFT: 376px; POSITION: absolute; TOP: 104px" runat="server" BorderColor="#E0E0E0" Text="检测" BackColor="#E0E0E0" CausesValidation="False"></asp:button>
<hr style="Z-INDEX: 125; LEFT: 16px; POSITION: absolute; TOP: 48px" color="#336699">
</FONT>
</form>
</body>
</HTML>
private void RRegister_Click(object sender, System.EventArgs e)
{
//创建数据库的连接
SqlConnection myConnection = new SqlConnection(ConnectionString);
//判断此用户是否存在
string cmdText = "select UserName from Users where UserName = '"+RUsersName.Text+"'";
SqlCommand myCommand = new SqlCommand(cmdText,myConnection);
myConnection.Open();
SqlDataReader dr=myCommand.ExecuteReader();if(dr.Read())
{
Response.Write("<script>alert(\"此用户名已经存在!\")</script>");//存在就提示用户
}
else
{
dr.Close();//判断用户的Email地址是否重复
string cmdText3 = "select UserID from Users where Email = '"+REmail.Text+"'";
SqlCommand myCommand3 = new SqlCommand(cmdText3,myConnection);
SqlDataReader dr3=myCommand3.ExecuteReader();
if(dr3.Read())
{
Response.Write("<script>alert(\"此Email已经存在!\")</script>");//存在就提示用户
}
else
{
dr3.Close();//给出当前注册用户的ID
string uid = "select max(UserID) from Users";
SqlCommand myCommand2 = new SqlCommand(uid,myConnection);
int id = (int)myCommand2.ExecuteScalar();
id = id + 1;
//将用户信息填到数据库
string cmdText1 = "insert into Users(UserID,UserName,Password,Email,RoleID)values('"+id+"','"+RUsersName.Text+"','"+RPassword.Text+"','"+REmail.Text+"','"+2+"')";
SqlCommand myCommand1 = new SqlCommand(cmdText1,myConnection);
myCommand1.ExecuteNonQuery();
myConnection.Close();//将用户名的TEXTBOX清空
RUsersName.Text = "";
Session["UserID"]=id;
Response.Redirect("RegisterSuccess.aspx");
}
}
}
我的QQ是278591756,webwait(webwei)和wxt89307321(天使的左翼)可不可以加我一下啊,我想向你们学习
我现在也在写论坛,我原来用jsp写过一个
不过我用asp.net的写的时候不知道这是怎么实现的:大版面下有几个小版面,是用dataview实现的吗,可是这要读两张表,而且读一条大版面的记录,要把小版面都显示出来,依次循环,我实在没有了思路,请帮忙
我的email:[email protected]
谢谢