增加用户

/// <summary>
  /// 注册用户
  /// </summary>
 
    private const string parm_blogtitle = "@blogerloginname";
    private const string parm_blogerusername = "@blogerusername";
    private const string parm_blogerpassword = "@blogerpassword";
    private const string parm_blogerpublicname = "@blogerpublicname";
    private const string parm_blogeremail = "@blogeremail";
    private const string insertblogstr = "insert into bloger (blogerloginname,blogerusername,blogerpassword,blogerpublicname,blogeremail)  "
        +" values (@blogerloginname,@blogerusername,@blogerpassword,@blogerpublicname,@blogeremail)";
 

    public bool insertbloger(string blogname,string publicname,string username,string email , string blogpassword)
    {
        SqlCommand cmd = new SqlCommand();
        SqlParameter[] newparms = new SqlParameter[]{
                new SqlParameter(parm_blogtitle,SqlDbType.NVarChar,200),
                new SqlParameter(parm_blogerusername,SqlDbType.NVarChar,200),
                new SqlParameter(parm_blogerpassword,SqlDbType.NVarChar,200),
                new SqlParameter(parm_blogerpublicname,SqlDbType.NVarChar,200),       
                new SqlParameter(parm_blogeremail,SqlDbType.NVarChar,200)
        };
        newparms[0].Value = blogname;
        newparms[1].Value = publicname;
        newparms[2].Value = username;
        newparms[3].Value = email;
        newparms[4].Value = blogpassword;

        int intvalue = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, insertblogstr, newparms);
        if(intvalue > 0)
        {
            return true;
        }
        else
        {
            return false;
        }

    }

原文地址:https://www.cnblogs.com/eebb/p/746346.html