日期:2014-05-17  浏览次数:20370 次

asp.net用户注册的问题
帮帮忙看一看下面用户注册的代码,就是不对,提交就说User附近用错 
public partial class Register : System.Web.UI.Page
  {
  private SqlConnection objConnection;
  protected void Page_Load(object sender, EventArgs e)
  {
  objConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["hui"].ConnectionString.ToString());
  // new SqlConnection(ConfigurationSettings.AppSettings["hui"]);
  }

  protected void Btn_Register_Click(object sender, EventArgs e)
  {
  objConnection.Open();
  string username = txtUserName.Text.ToString().Trim().Replace("'", "''");  
  string strSelReg = "select * from User where UserName='" + username + "'";
  SqlCommand myCommandReg = new SqlCommand(strSelReg, objConnection);
  SqlDataAdapter myDbAdapterReg = new SqlDataAdapter(myCommandReg);
  DataSet myDataSet = new DataSet();
  myDbAdapterReg.Fill(myDataSet,"User");<---有错的地方,User是我建的用户表
  objConnection.Close();
  if (myDataSet.Tables["User"].Rows.Count > 0)
  {
  LB_Wrong.Text = "英雄略有所同,你刚刚想注册的用户名已经被人注册了!换个用户名试试!";
  }
  else
  {
  string userpass = txtPassword.Text.ToString().Trim().Replace("'", "''");
  string usersex;
  if (Sex_B.Checked)
  {
  usersex = "帅哥";
  }
  else
  {
  usersex = "靓妹";
  }
  string userquest = txtPassQuest.Text.ToString().Trim().Replace("'", "''");
  string useranswer = txtPassAnswer.Text.ToString().Trim().Replace("'", "''");
  string email =txtEmail.Text.ToString().Trim();
  string homepage =txtHomePage.Text.ToString().Trim();
  int qq;
  if (QQ.Text.ToString() == "")
  {
  qq = 0;
  }
  else
  {
  qq = System.Convert.ToInt32(QQ.Text.ToString());
  }
  string birthday = Birthday.Text.ToString().Trim();
  string signature = Signature.Text.ToString().Replace("'", "''");
  string time = DateTime.Now.ToString();
  objConnection.Open();
  string updateStr = "insert into User (UserName,Password,Sex,HomePage,Email,QQ,Birthday,Signature,PassQuest,PassAnswer) VALUES ('" + username + "','" + userpass + "','" + usersex + "','" + homepage + "','" + email + "'," + qq + ",'" + birthday + "','" + signature + "','" + userquest + "','" + useranswer + "')";
  SqlCommand myCommandUpate = new SqlCommand(updateStr, objConnection);
  myCommandUpate.ExecuteNonQuery();
  objConnection.Close();
  Response.Write("注册成功");
  //Response.Redirect("success.aspx?action=reg");