VIP会员
购物车
私信
发表新帖
立即签到
关注
回复
支持(
反对( 首页上一页 1 下一页尾页 1 条记录 1/1页
求助第十四章-网站会员注册与登录的问题
发表在ASP.NET图书答疑
2008-04-28
是否精华
是
否
版块置顶:
是
否
我在第14章-网站会员注册与登录时遇到了如下的问题, <BR>代码用的还是书中案例的代码,SQL里而的数据类型也是按照书上的设置的,但是在点击注册按钮时,出现如下错误: <BR>将截断字符串或二进制数据。 <BR>语句已终止。 <BR><BR>请问是什么原因,请告之,非常感谢,盼之 <BR>代码如下: <BR>using System; <BR>using System.Data; <BR>using System.Configuration; <BR>using System.Web; <BR>using System.Web.Security; <BR>using System.Web.UI; <BR>using System.Web.UI.WebControls; <BR>using System.Web.UI.WebControls.WebParts; <BR>using System.Web.UI.HtmlControls; <BR>using System.Data.SqlClient; <BR><BR>public partial class _Default : System.Web.UI.Page <BR>{ <BR> protected void Page_Load(object sender, EventArgs e) <BR> { <BR> <BR> } <BR><BR> protected void ButtonLogin_Click(object sender, EventArgs e) <BR> { <BR> int i = isName();//调用自定义方法接受一个整数类型 <BR> if (i <= 0) <BR> { <BR><BR> if (add())//调用自定义方法 <BR> { <BR> //把注册时间和会员名 添加到日志数据库中 <BR> SqlConnection con = this.createLoginConn(); <BR> con.Open(); <BR> SqlCommand com = new SqlCommand("insert hyyx values('" + Textname.Text + "','" + DateTime.Now.ToString() + "')", con); <BR> com.ExecuteNonQuery(); <BR> Response.Write("<script>alert('注册成功！单击确定返回登陆页面');location='landing.aspx';</script>"); <BR> con.Close(); <BR> } <BR> else <BR><BR> Response.Write("<script>alert('注册失败！')</script>"); <BR> } <BR> else <BR> { <BR> Response.Write("<script>alert('会员名已经存在！')</script>"); <BR> } <BR> } <BR> public bool add() <BR> { <BR> string name = Textname.Text; <BR> //使用MD5把用户添加的密码进行加密 <BR> string pass = FormsAuthentication.HashPasswordForStoringInConfigFile(TextPass.Text, "MD5"); <BR> string sex; <BR> //获取性别 <BR> if (RadioButtonMan.Checked) <BR> { <BR> sex = "男"; <BR> } <BR> else <BR> { <BR> sex = "女"; <BR> } <BR> string trueName = TextTrueName.Text;//获取真实姓名 <BR> string phone = TextPhone.Text; //获取电话 <BR> string address = TextAddress.Text; //获取地址 <BR> string email = TextEmail.Text; //获取电子邮件 <BR> string sql = "insert into hyyx values('" + name + "','" + pass + "','" + sex + "','" + trueName + "','" + phone + "','" + email + "','" + address + "')"; <BR> SqlConnection con = this.createLoginConn();//调用自定义方法获取SqlConnection实例 <BR> con.Open(); <BR> SqlCommand com = new SqlCommand(sql, con); <BR> int i = Convert.ToInt32(com.ExecuteNonQuery());//返回受影响的行数 <BR> if (i > 0) <BR> { <BR> return true; <BR> } <BR> else <BR> { <BR> return false; <BR> } <BR><BR> con.Close(); <BR> } <BR> protected SqlConnection createLoginConn() <BR> { <BR> SqlConnection con = new SqlConnection("server=.;database=hydl;uid=sa;pwd=001;"); <BR> return con; <BR> } <BR><BR> protected void Button2_Click(object sender, EventArgs e) <BR> { <BR><BR> } <BR><BR> <BR><BR> <BR> protected int isName() <BR> { <BR> int i; <BR> //把获取的会员名通过MD5加密 <BR> string name = Textname.Text; <BR> if (name.Trim() != "") <BR> { <BR> SqlConnection con = createLoginConn(); //获取SqlConnection实例 <BR> con.Open(); <BR> SqlCommand com = new SqlCommand("select count(*) from hyyx where Name='" + name + "'", con); <BR> return i = Convert.ToInt32(com.ExecuteScalar()); <BR> con.Close(); <BR> } <BR> else <BR> return i = 1; <BR> } <BR> protected void ButtonisName_Click(object sender, EventArgs e) <BR> { <BR> int i = isName(); <BR> if (i > 0) <BR> { <BR> RegisterStartupScript("yes", "<script>alert('会员名已经存在！')</script>"); <BR> } <BR> else <BR> { <BR> RegisterStartupScript("no", "<script>alert('可以注册')</script>"); <BR> } <BR> } <BR>} <BR><BR><BR>其中:hydl是数据库名,hyyx是存储注册的信息表,其中的 <BR>name varchar(50) <BR>pass varchar(50) <BR>sex char(10) <BR>tureName varchar(50) <BR>phone varchar(50) <BR>email varchar(50) <BR>address char(10)
分享到：
