.net注册页面数据写入数据库2(注册信息)

作者: 许泽博　发布: 2016/8/25　分类: 网站　阅读: 次　查看评论

protected void btnRegiste_Click(object sender, EventArgs e)
    {
        string connStr = "data source=localhost;user id=sa;password=;initial catalog=Sale";
        SqlConnection conn = new SqlConnection(connStr);
        //SqlCommand cmd = conn.CreateCommand();
        //cmd.CommandText="insert into userinfo values(@UserName,@Password,@RealName,@Gender,@Phone,@Email,@Address)";
  cmd.Parameters.Add("@UserName",tbUsername.Text.Trim());
  cmd.Parameters.Add("@Password",tbPassword1.Text.Trim());
  cmd.Parameters.Add("@RealName",tbRealname.Text.Trim());
  cmd.Parameters.Add("@Gender",dlGender.SelectedValue.ToString().Trim());
  cmd.Parameters.Add("@Phone",tbPhnoeno.Text.Trim());
  cmd.Parameters.Add("@Email",tbEmail.Text.Trim());
  cmd.Parameters.Add("@Address",tbAddress.Text.Trim());
  //执行

        //存储过程返回值
        SqlParameter paramOut = cmd.Parameters.Add("@RETURN_VALUE","");
        paramOut.Direction = ParameterDirection.ReturnValue;

        try
        {
            //打开数据库
            conn.Open();
            cmd.CommandText = "insert userinfo values(&tbUsername.Text&,&tbPassword1&,&tbRealname.Text&,&dlGender.SelectedValue&,&tbPhnoeno.Text&,&tbEmail.Text&,&tbAddress.Text&)";
            cmd.ExecuteNonQuery();

            if ((int)cmd.Parameters["@RETURN_VALUE"].Value == 0)
            {
                Response.Write("<h3 color=red>注册成功！</h3>");
              
            }
            else
            {
                Response.Write("<h3 color=red>该用户已经存在！</h3>");
            }
        }
        catch (SqlException ex) //数据访问异常
        {
            Response.Write("数据访问错误！\n");
            Response.Write(ex.Message);
        }
        catch (Exception ex) //其他异常
        {
            Response.Write("错误\n");
            Response.Write(ex.Message);
        }
        finally //关闭数据连接
        {
            conn.Close();
        }

    }

« 上一篇下一篇 » 原创文章，转载请注明出处！标签: 网站  SQLserver