public bool UpdatePasswordOfUser(int uid, string newPassword)
{
bool flag = false;
string sql = "update [_Users] set [_Password]=@newPassword where [_UserId]=@uid";
SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@newPassword", SqlDbType.NVarChar), new SqlParameter("@uid", SqlDbType.Int) };
paras[0].Value = newPassword;
paras[1].Value = uid;
//SqlCommand sqlcmd = sqlhelper.GetCommand(sql, paras);
if (sqlhelper.ExecuteNonQuery(sql, paras, CommandType.Text) > 0)
{
flag = true;
}
return flag;
}
{
bool flag = false;
string sql = "update [_Users] set [_Password]=@newPassword where [_UserId]=@uid";
SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@newPassword", SqlDbType.NVarChar), new SqlParameter("@uid", SqlDbType.Int) };
paras[0].Value = newPassword;
paras[1].Value = uid;
//SqlCommand sqlcmd = sqlhelper.GetCommand(sql, paras);
if (sqlhelper.ExecuteNonQuery(sql, paras, CommandType.Text) > 0)
{
flag = true;
}
return flag;
}