菜鸟高分求助!!!!!!!!!!!!!!!!
我有一个user表,里面有name、password、email这三个字段,现在弄一个注册页面,后台代码如下
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
using System.Data.Sql;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["userConnectionString"].ConnectionString;
conn.Open();
SqlCommand Cmd=new SqlCommand();
Cmd.Connection=conn;
Cmd.CommandText="select[name]form[User]";
SqlDataReader dr = Cmd.ExecuteReader();
while(dr.Read())
{
if(dr.GetString(0)==TextBox1.Text)
{
Label3.Text=TextBox1+"已经存在!";
conn.Close();
return;
}
}
conn.Close();
string SqlStr;
SqlStr="Insertinto[User]([name][password],[email])values(@name,@password,@email)";
Cmd.CommandText=SqlStr;
SqlParameter para1=new SqlParameter("@name",SqlDbType.VarChar,50);
para1.Value=TextBox1.Text;
Cmd.Parameters.Add(para1);
SqlParameter para2=new SqlParameter("@password",SqlDbType.VarChar,50);
para1.Value=TextBox2.Text;
Cmd.Parameters.Add(para2);
SqlParameter para3=new SqlParameter("@email",SqlDbType.VarChar,50);
para1.Value=TextBox3.Text;
Cmd.Parameters.Add(para3);
try
{
conn.Open();
Cmd.ExecuteNonQuery();
Label3.Text="恭喜你,注册成功";
}
catch(SqlException sqlException)
{Response.Write(sqlException.Message);}
finally
{
if(conn.State==ConnectionState.Open)
conn.Close();
}
}
}
运行出错,找了半天找不到,到底错在那里