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");